perform worse than clustered indexes on ranged searches where the result set is large, since each result could cost an additional I/O-operation to get the actual data record

search for b># using non-clustered index on b

en.wikipedia.org —  Index (database) - Wikipedia, the free encyclopedia Add comments

Block

A clustered index sorts and stores the data rows in the table based on the index key values. Therefore only one clustered index can be created on each table because the data rows themselves can only be sorted in one order.

Q1 a) Explain why it is not possible to have more than one clustered index per relation

msdn.microsoft.co... —  Only one clustered index can be created on table <Tablename>. (Visual Database Tools) Add comments

Block