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
146207 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 the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

949

What protocol does sql server use?

895

What are the requirements to use odbc connections in php scripts?

1078

What is sql server used for?

1004

What are sparse columns?

963

What is dbcc? Give few examples.

966

How do I view a script in sql server?

989

How does a profiler work?

882

Define Wed Edition in SQL Azure?

100

Describe triggers features and limitations?

936

What are the five characteristics of good data?

882

What is sql server locking?

950

What are the dmvs?

959

How to define output parameters in stored procedures?

975

How to get a list of columns in a view using the "sp_columns" stored procedure?

999