Clustered Vs Non-Clustered Indexes: A Clear Explanation
Clustered Index sorts data by emp_id, Non-Clustered Index by emp_name. Clustered Index determines physical storage, Non-Clustered Index improves query performance with pointers to rows.
Let's walk through an example with Employee ID as the Clustered Index and Employee Name as the Non-Clustered Index to illustrate the concepts more clearly. Sample Table: Employees Step 1: Clustered Index on emp_id When we create a Clustered Index on emp_id, the rows of the Employees table will be physically stored on disk in ascending order of emp_id. The Clustered Index determines the physical order of the data in the table. So, after creating a Clustered Index on emp_id, the data rows in the table will be stored in the following order: Key Concept: Since emp_id is the Clustered Index, the ta...