yes, we can create the cluster index on non prime attribute if it is uniq

Can we create clustered index on non primary key column

Question Posted / grish varshney

Answer Posted / grish varshney

yes, we can create the cluster index on non prime attribute
if it is unique & there is no prime attribute bcoz the
cluster index should be once..

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are the steps to follow to configure SQL*Net?

992

What is code near application topology?

271

What is ms sql server service broker?

932

What is logon trigger?

1028

What is the difference between executequery () and executeupdate ()?

964

Why is sql server log file full?

977

What is the difference between char and varchar2 datatype in sql?

1007

What are scalar functions in sql?

1078

Can you leave a union at any time?

999

What do we need queues in sql service broker?

1003

How to read data in a table with "select" statements?

918

What does executeupdate return?

927

What is difference between views and stored procedures?

928

Is null vs coalesce?

816

What is bookmark link in ssrs?

234