Secondary 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.

About the Author

Photo of Markus Winand
Markus Winand tunes developers for high SQL performance. He also published the book SQL Performance Explained and offers in-house training as well as remote coaching at http://winand.at/

?Recent questions at
Ask.Use-The-Index-Luke.com

0
votes
2
answers
728
views

different execution plans after failing over from primary to standby server

yesterday Markus Winand ♦♦ 741
oracle index update
1
vote
1
answer
61
views

Generate test data for a given case

Sep 14 at 18:11 Markus Winand ♦♦ 741
testcase postgres
0
votes
1
answer
208
views

Database design suggestions for a data scraping/warehouse application?

Aug 27 at 09:29 Markus Winand ♦♦ 741
mysql optimization database