Add to Chrome
An index that is maintained without regard to the physical order of the underlying data.
An index constructed in a random order based on hash values.
An index that only indexes modified records and ignores static data.
An index where entries are stored in the same order as the data records, facilitating efficient range queries.
MRU leads to fewer I/O operations than LRU
LRU leads to fewer I/O operations than MRU
Both LRU and MRU lead to same number of I/O operations
9
8
7
6
The clustering index determines the physical order, while the non-clustering index is maintained separately and may contain multiple pointers to the same record.
The clustering index is always implemented as a dense index, whereas the non-clustering index is always implemented as a sparse index.
Both indexes determine the physical order of the records in the table.
The non-clustering index always results in faster query performance than the clustering index.
4
3
2
5
Reduced disk seek time
Optimized analytical query performance
Better support for ACID transactions
Faster transactional updates
The page ID of the next block
Actual tuple data
Number of total pages in the file
Record offsets within the page
Sector Alignment
Block size
Rotational latency
Distance between requested and current track
Storage Density
Sequential Access Speed
Cache Size
Latency