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
147104 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

What is indexing explain it with an example?

1013

Tell me what is log shipping?

977

What is sql server transaction log file?

1058

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

922

What are the different types of triggers in SQL SERVER?

1139

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

973

What are the differences between char and nchar in ms sql server?

1087

Explain alternate key, candidate key and composite key in sql server?

916

How to optimize stored procedure optimization?

894

What sql server means?

970

What are the different types of data sources in ssrs?

196

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

1007

What are the instances when triggers are appropriate?

979

what is a deadlock? : Sql server database administration

1067

What is field in algebra?

1038