indexing

Question

In a table, i have 1 primary key,2 unique key and i foreign key. how many indexing can i create.

Upendra Pratap Shahi · Answer

Which version of SQL server you are using. Indexing depends on version of SQL. In 2005- Total Index is- 250(1 cluster and 249 non-cluster index) On primary key 1 clustered index unique - 2 non clusterd index on foreign key no index by default remain-247 non clustered index In 2008- Total Index is- 1000(1 cluster and 999 non-cluster index) On primary key 1 clustered index unique - 2 non clusterd index on foreign key no index by default remain-997 non clustered index If this helped you kindly accept the answer .

Upendra Pratap Shahi · Answer

Thanks for appreciation Pramod Gupta.

Pramod Gupta · Answer

welcome Upendra

Sivaraman Dhamodaran · Answer

The below given article explains that: http://www.mstecharticles.com/2011/02/clustered-and-non-clustered-index-in.html

Raja T · Answer

https://msdn.microsoft.com/en-us/library/aa933131.aspx ----------------------- https://msdn.microsoft.com/en-us/library/ms143432.aspx ----------------------- http://stackoverflow.com/questions/4618387/how-many-clustered-indexes-there-can-be-in-one-table

Raja T · Answer

Hi,PRIMARY KEY constraints create clustered indexes automatically if no clustered index already exists on the table and a nonclustered index is not specified when you create the PRIMARY KEY constraint. As per my understanding create 2 indexing for unique key columns only...

indexing

Answers (6)