How many index can be created for single table
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 |
Post New Answer View All Answers
What are data regions?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is a trigger in sql server?
How is SQL Azure different than SQL server?
Explain four layers of abstraction microsoft architectured?
Explain alternate key, candidate key and composite key in sql server?
How to replace null values in expressions using isnull()?
What are the different authentication modes in sql server? How can it be changed?
How do I find the sql server version?
What is oltp (online transaction processing)?
Determine when an index is appropriate?
What are the default system databases in sql server 2000?
How do you delete a data source?
How do I setup a sql server database?