http://yousticker.com/boomer4youhttp://yousticker.com/boomer4you/sticker/954538http://yousticker.com/boomer4you/sticker/954538http://yousticker.com/boomer4you/sticker/954538 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
]]>http://yousticker.com/boomer4you/sticker/954053http://yousticker.com/boomer4you/sticker/954053http://yousticker.com/boomer4you/sticker/954053 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.
]]>