Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54888 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 stored by the master? : sql server database administration
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Where is localdb stored?
What is mapping schema?
What is a ddl statement?
where can you add custom error messages to sql server? : Sql server administration
What is a functions and types in sql server?
how to trace the traffic hitting a sql server? : Sql server database administration
What is the syntax to execute the sys.dm_db_missing_index_details?
Can sql servers link to other servers?
How do you start single user mode in clustered installations?
What is a unique key constraint?
What is SQL Azure Federations?
explain different types of cursors? : Sql server database administration
How to use the inserted and deleted pseudo tables?
