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



topicsexpress.com/TODAY’S-WORD-from-Joel-and-Victoria-I-had-a-man-tell-me-a-few-topic-10200651230706891">TODAY’S WORD from Joel and Victoria I had a man tell me a few
viagra fabric
Organic Compounds of Sulphur, Selenium and Tellurium (SPR Organic
So, can I get an informal vote about quantity or quality? As
#TBT 25 years ago this week I was getting ready to start UT and I

Recently Viewed Topics




© 2015