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

What are data regions?

135

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

900

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

972

What is a trigger in sql server?

1162

How is SQL Azure different than SQL server?

223

Explain four layers of abstraction microsoft architectured?

147

Explain alternate key, candidate key and composite key in sql server?

908

How to replace null values in expressions using isnull()?

1098

What are the different authentication modes in sql server? How can it be changed?

1080

How do I find the sql server version?

1016

What is oltp (online transaction processing)?

1002

Determine when an index is appropriate?

1070

What are the default system databases in sql server 2000?

1022

How do you delete a data source?

1002

How do I setup a sql server database?

1065