top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

What are the different index configurations a table can have?

+1 vote
40 views
What are the different index configurations a table can have?
posted Dec 2, 2014 by Balu

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

A table can have one of the following index configurations:
No indexes
A clustered index
A clustered index and many nonclustered indexes
A nonclustered index
Many nonclustered indexes

answer Dec 2, 2014 by Manikandan J
Similar Questions
+4 votes

My table is too big and now i realize that i need to add few columns in that, but when i tried to do this, my alter script took more then 4 hours and database performance also got degraded, so i canceled the query, can anyone suggest better way of doing that

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...