clustered index: if there is any primary key then then its clustered index.

Difference between Cluster and Non-cluster index?

Question Posted / sangram nayak

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

Answer Posted / sangram nayak

clustered index: if there is any primary key then then its clustered index.only one clustered index can be possible.

Non clusterd index: whenever you are creating any index on any column then that is non clustered index.multile non clusted index is possible.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about link server in sql server?

1001

How do you check sql server is up and running?

933

What is meant by indexing?

939

What is store procedure? How do they work? When do you use?

885

Does view occupy space?

885

How to insert stored procedure result into temporary table?

979

What is sleeping status in sql server?

981

What's new in sql management studio for sql server? : sql server management studio

995

Tell me about builtinadministrator?

945

How do I start sql server 2016?

857

What types of replication are supported in sql server?

997

Tell me what do you understand by a view? What does the with check option clause for a view do?

956

If any stored procedure is encrypted, then can we see its definition in activity monitor?

936

Explain the rules for designing files and file groups in sql server?

932

How to make a remote connection in a database?

925