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

4 Answers
18538 Views
CarrizalSoft Technologies, Verizon, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is equi join with example?

1136

What are the different types of stored procedures?

1118

Do you know what is lock escalation?

1016

Explain about SQL server 2005?

983

How to Update from select query in sql server?

1068

Explain few of the new features of sql server 2008 management studio

923

What is difference between views and stored procedures?

995

Explain boyce and codd normal form(bcnf)?

965

Can you insert NULL in unique column?

1167

What is the difference between a fill factor of 100 and 0?

986

Explain the concept of view and Types of views in SQL server?

995

Do you know hot add cpu in sql server 2008?

961

How to change the data type of an existing column with "alter table" statements in ms sql server?

988

What are unicode character string data types in ms sql server?

1265

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

957