Can we create clustered index on non primary key column

Answer Posted / laxman2610

Yes, But on that table primary key should be created with
non-clustered index and the columun u want to create a
cluster index is should be unique

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain data warehousing in sql server?

820


How would you go about developing a ssrs report?

135


What are different types of join?

1011


Define msdb database?

826


Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

163


Define indexes?

834


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

799


Do you know what are the restrictions that views have to follow?

858


What is open database communication (odbc)?

803


What are diverse clauses that form a part of sql?

846


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

810


Can we use custom code in ssrs?

837


How to connect ms access to sql servers through odbc?

775


how many clustered indexes can be created on a table? : Sql server database administration

832


How to select some specific rows from a table in ms sql server?

812