MYCH8
MYCH8
MYCH8
Chapter 8
DB
4 round blue 2
5 square blue 4
6 rectangle blue 8
4 blue
5 blue
6 blue
Index entries
CLUSTERED direct search for UNCLUSTERED
data entries
Non-leaf
Pages
Leaf
Pages
Leaf pages contain data entries, and are chained (prev & next)
Non-leaf pages contain index entries; they direct searches:
index entry
P0 K 1 P1 K 2 P 2 K m Pm
17
5 13 27 30
2* 3* 5* 7* 8* 14* 16* 22* 24* 27* 29* 33* 34* 38* 39*
(2) Sorted
(3) Clustered
(4) Unclustered
Tree index
(5) Unclustered
Hash index
use aworks;
create index IX_Product_Color
on SalesLT.Product (Color);
More Examples