About this document
Indexes SS3 by itzelrodrig0102 is a document available to read on EtoBox.
The document explains the differences between dense and sparse indexes, highlighting that dense indexes contain an entry for every search key value while sparse indexes point to groups of records. It also distinguishes between primary indexes, which are based on unique key columns and determine physical storage order, and secondary indexes, which are based on non-key fields and can contain duplicates. Additionally, it discusses composite search keys used for indexing multiple fields and the types of queries
- Author
- itzelrodrig0102
- Language
- EN