Can we create clustered index on non primary key column

Answer Posted / venkat

yes we can create clustured index on non primary key,
But that column has unique values.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain cursor as data base object?

566


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1679


What is the default value of an integer data type in sql server 2005?

579


Explain the usage of floor function in sql server.

498


What are the differences between local and global temporary tables?

545






How to count groups returned with the group by clause in ms sql server?

550


Why we use functions in sql server?

511


Can an automatic recovery be initiated by a user?

549


what is difference between view and Dip.

1990


Can you insert NULL in unique column?

616


You want to implement the many-to-many relationship while designing tables. How would you do it?

551


what are the important architecture components of SSRS?

92


Tell me what is the difference between locking and multi-versioning?

573


How can I add Reporting Services reports to my application?

91


what is a default tcp/ip socket assigned for sql server? : Sql server database administration

526