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
148053 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 an execution plan? How would you view the execution plan?

1123

What are the steps you can take to avoid “deadlocks”?

1019

What is shrink log file?

943

What are the benefits and tasks of object explorer? : sql server management studio

1245

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

991

How to use clusters?

1006

What are the differences between web role and worker role?

124

what authentication modes does sql server support? : Sql server database administration

1173

Define outer join in sql server joins?

982

What is data source in connection string?

952

what data regions are and what are the different data regions?

146

Explain the architecture of ms sql reporting service?

968

What is difference in performance between insert top (n) into table and using top with insert?

1113

When you use @@error and try-catch?

1086

What command would you use to create an index?

1101