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
1
answer
128
views

PostgreSQL Scripts: Performance Testing and Scalability problem and question

Nov 12 at 14:53 Markus Winand ♦♦ 936
testing postgresql scalability
0
votes
1
answer
498
views

PostgreSQL Bitmap Heap Scan on index is very slow but Index Only Scan is fast

Oct 31 at 11:31 Markus Winand ♦♦ 936
index postgresql postgres sql
3
votes
2
answers
552
views

pagination with nulls

Oct 29 at 22:39 Rocky 46
pagination