If I create cluster Index on one column of a table then clustered - TopicsExpress



          

If I create cluster Index on one column of a table then clustered index contains all the columns of a table? If yes then why we need Non Clustered index because cluster index suffice for all filtering condition. I gone through 100+ blogs but I am not clear. I am practically checked the query plan sometime it takes clustered seek, clustered scan and some time non clustered seek. I have attached the screenshot below.
Posted on: Fri, 07 Nov 2014 12:09:29 +0000

Trending Topics



Recently Viewed Topics




© 2015