Question: what is the difference between index and clustered index?
Answer: Both Clustered Index and Nonclustered Indexes have same physical structure in SQL Server. Both are stored as a B-Tree structure in SQL Server. A Table can have ONLY 1 Clustered Index. ... A Primary Key constraint can also be enforced by Nonclustered Index, You can specify the index type while creating Primary Key.