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 to convert a unicode strings to non-unicode strings?

1152

List some advantages and disadvantages of stored procedure?

1063

Find first and last day of current month in sql server

1080

What is a View ? Can we insert, Update and delete a view?

1059

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

984

What is 2nf in normalization?

1054

How do you trace the traffic hitting a sql server?

1189

What is the temp table?

974

Explain primary key and foreign key constraints?

1089

What is a livelock?

1014

What function does a database engine serve in the sql server?

1079

How to get the definition of a stored procedure back?

1018

What are the differences between having and where clause.

1016

What are the diifferences between the ms sql server vs mysql?

1234

What specific conditions database should meet, before you can bulk copy data into it using bcp?

1038