Can we create clustered index on non primary key column
Answer Posted / leelavinoth
I have created CLUSTERED on NON-PRIMARY Attribute because i
want my table has to be ordered in NON-PRIMARY column.
Because, most on my search and filtering will be on this
NON-PRIMARY column.
Is there any harm in this! Please recommend
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is thr feature of change data capture?
What is for xml in sql server?
What is the difference between count and distinct count?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Define indexes?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
How do I create an extended event in sql server?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Why use “in” clause in sql server?
Tell me what is de-normalization and what are some of the examples of it?
What is dbcc? Give few examples.
What is difference between stored procedure and user defined function?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
Explain what is meant by replication of database?
How many types of the database links?