why a table has 249 nonclusterd indexes ?

Posted by Ksuresh.techno under Sql Server on 2/1/2010 | Views : 1437 | Status : [Member] | Replies : 1
why a table has 249 nonclusterd indexes ? . and only one clustered index?
i was faced this qsn in Timken interview.




Responses

Posted by: Abhi2434 on: 2/1/2010 [Member] [Microsoft_MVP] [MVP] Silver

Up
0
Down
Read this
http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx

I am sure you will get everything clear.

Cheers.

www.abhisheksur.com

Ksuresh.techno, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response