Nonclustered indexes Leaf level contains Columns of index 」 Bookmark to data row Bookmark is either 口RID(Fe#,Page#Sot# Unique clustered index key If overlap between clustered and nonclustered keys, value is stored only once s Rows are in order by first index column A Scan can be done on the leaf levelNonclustered Indexes ◼ Leaf level contains ◼ Columns of index ◼ Bookmark to data row ◼ Bookmark is either: ◼ RID (File #, Page #, Slot #) ◼ Unique clustered index key ◼ If overlap between clustered and nonclustered keys, value is stored only once ◼ Rows are in order by first index column ◼ A Scan can be done on the leaf level