- August 12–22: Online Training (EU shift)
- Enrollment
- FOSDEM Impressions
- June 8–18: Online Training (US shift)
- Non-monetary micro sponsoring
- November 11-12 in Frankfurt am Main
- Online-Training in July and August
- Oracle + PostgreSQL
- Party time
- PostgreSQL Performance Event
- SQL Server Performance Kurs in Stuttgart
- SQL Server performance training in London
- Shipping Terms
- The two top performance problems caused by ORM tools
- Top Tweets January 2013
- Training Survey
- Training and Conference Dates
- Use The Index, Luke
- Ask
- Consulting
2011-11-08Secondary Index
A secondary index is an index that refers to a clustered index (SQL Server, MySQL/InnoDB) or Index-Organized Table (Oracle). In other words, an index on an index.
Accessing table data via a secondary index is slower than a similar query on a heap-table.
Links
Book-Section: Index-Organized Tables
Glossary: Heap-Table — Tables stored in an unordered fashion.
Glossary: Clustered Index — Table stored in a B-Tree index
Glossary: Index-Organized Table — Oracle clustered index
About the Author
As an author, trainer, and coach Markus Winand specializes in helping developers cope with SQL performance issues. He also published the book SQL Performance Explained and tweets his best performance tips via @SQLPerfTips.http://winand.at/
Stay connected:
RSS Feed
Like on Facebook
Follow me on Twitter
Share at Google+
RSS FeedFlattr this! Follow me on TwitterShare at Google+Like on Facebook