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 are two difference between sql azure and azure tables?
What are the differences between local and global temporary tables?
System requirements for sql server 2005 express edition?
Will count(column) include columns with null values in its count?
Define union, union all, minus, intersect?
Explain about builtinadministrator?
What is a cache in ssrs?
Can you name a few encryption mechanisms in sql server?
What is the difference between clustered index and primary key?
List the different types of joins?
What is an etl file?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What do you understand by mirroring and mention the advantages of the mirroring?
What is use of dbcc commands?
What are the different types of join?