We can create total 250 indexes per table . i,e 1 Clustered Index and 249

How many index can be created for single table

Question Posted / somu

Answer Posted / somu

We can create total 250 indexes per table . i,e 1 Clustered
Index and 249 Non Clustered Indexes

Is This Answer Correct ?

25 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How will you find out if there are expensive SQL statements running or not?

980

What is a file group?

1031

How to create user messages with print statements in ms sql server?

947

Why use triggers?

977

What are “phantom rows”?

1622

What is the difference between dataadapter and datareader?

955

How to insert data with null values?

980

What are the restraints imposed on the table design by a merge replication?

994

Tell me something about security and sql azure?

114

How to find the version of sql server? : sql server database administration

1057

How to achieve Paging of records in SQL SERVER?

1059

How to Insert multiple rows with a single insert statement?

1015

how you can list all the tables in a database?

978

how will add additional conditions in sql?

1031

How do you implement session management in SQL Server mode?

1036