SQL Training - 05

Clustered and Non-Clustered Indexes:

• Each table can have one Clustered Index and many columns in this clustered Index.
• Each page can have 8.1KB
• When you add more than one column in the clustered the pages will increase and the access time will increase.
• Recommended to Add a clustered indexes on each table.
• You can remove the primary key from the clustered index and add any other columns.
• Each primary key is a clustered index and a clustered could contains non-primary key.
• Each table doesn't have a clustered index called heap.
• Phone book is clustered; the pages already contains the data.
• Non-clustered index is pointer; like book Index.