Indexing is basically working by means of sorting of the columns.
When you create a primary key field a Clustered Index will automatically created. And once that created ou cann't add more clustered index to that table.
This is because there is already a clustered index there and there is no other posibility for sorting the other row since the indexes are working by means of sort.
Asked In: Many Interviews |