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
How do I create a stored procedure in sql server?
Explain cdc and sql injection?
What is the difference between dbcc indexdefrag and dbcc reindex?
How to get the number of affected rows?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is difference between views and stored procedures?
Explain the different types of backups available in sql server? : sql server database administration
What is report subscription?
What is merge?
What is the difference between count and distinct count?
Can a database be shrunk with users active?
Tell me what do we need queues in sql service broker?
How to create an multi-statement table-valued function?
Write a sql query to display the current date?
What are window functions in sql server?