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

Explain what is the difference between a local and a global temporary table?

1003

Explain what is the main purpose of having conversation group?

940

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

901

What happens if null values are involved in bitwise operations?

1027

Name some of the open source software that you can use in alternative to SSR?

161

Explain the steps to use transact-sql cursor?

1063

Where the sql logs gets stored? : sql server database administration

964

What are the advantages of the mirroring?

1094

What is a linked server in sql server?

1075

What are different types of schemas?

947

Do you know what is fill factor and pad index?

1004

Tell me what is difference between clustered and non clustered index?

944

How do I find information about the install locations for the various instances running on a computer?

1085

How to set the current database in ms sql server?

1081

How to insert multiple rows with one insert statement in ms sql server?

1124