Can we create clustered index on non primary key column
- 20 Answers
- 51549 Views
- ABC, CTS, I also Faced
- E-Mail Answers
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 Federation Root Database?
What is mean by candidate key?
How do you trace the traffic hitting a sql server?
query processing
How to round a numeric value to a specific precision?
What do you understand by triggers and mention the different types of it?
What do you mean by an execution plan? How would you view it?
what is database replication? : Sql server database administration
What is the command used to check locks in microsoft sql server?
Explain about nested stored procedure?
Explain about integration services of Microsoft SQL server?
What is SQL Azure Firewall?
Can another user execute your local temporary stored procedures?
Explain the various types of concurrency problem?
When to use null data driven subscription?
