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 the disadvantages of cursors? : Sql server database administration

495

What are the basic functions for master, msdb, model, tempdb and resource databases?

557

Define clusters?

652

Explain filestream storage of sql server 2008?

520

What is a recursive stored procedure in sql server?

571

Describe and explain about SQL native client?

622

How to add an address record into adventureworkslt?

570

How we can refresh the view?

596

Explain the disadvantages/limitation of the cursor?

566

How to rebuild all indexes on a single table?

591

What is precedence constraint?

546

What is the difference between drop table and truncate table?

494

What are the differences between local and global temporary tables?

561

What command is used to rename the database?

529

What is an index. What are the types?

585