clustered index is physically stored a table can have 1 clustered index

Difference between Cluster and Non-cluster index?

Question Posted / p.karthick

32 Answers
148118 Views
Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
E-Mail Answers

Answer Posted / p.karthick

clustered index is physically stored
a table can have 1 clustered index

non clustered index is logically stored
a table can have 249 non clustred index

Is This Answer Correct ?

193 Yes

46 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to verify the port number of the sql server?

1246

How to create and drop temp table in sql server?

1098

can an order by clause be used in a creation of a view?

1234

How to drop existing indexes in ms sql server?

1126

Is ssrs support other database except ms sql server?

142

Tell me what is the significance of null value and why should we avoid permitting null values?

1038

How do I start sql server agent automatically?

1021

What is sql server 2000 work load governor?

1157

Do you know nested transaction?

997

How to query multiple tables jointly?

1039

Can two tables have the same primary key?

1263

When I run the sql server 2000 setup, it just hangs. What do I do?

1124

Explain identity in sql server?

1052

How to find the list of fixed hard drive and free space on server?

1278

What is the minimum recommended amount of ram for sql server 2012 enterprise?

975