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
Explain data warehousing in sql server?
How would you go about developing a ssrs report?
What are different types of join?
Define msdb database?
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?
Define indexes?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Do you know what are the restrictions that views have to follow?
What is open database communication (odbc)?
What are diverse clauses that form a part of sql?
You want to implement the many-to-many relationship while designing tables. How would you do it?
Can we use custom code in ssrs?
How to connect ms access to sql servers through odbc?
how many clustered indexes can be created on a table? : Sql server database administration
How to select some specific rows from a table in ms sql server?