Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54121 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
You want to implement the many-to-many relationship while designing tables. How would you do it?
How to get a list of columns in a view using the "sp_columns" stored procedure?
How you can find out if an index is useful to the optimizer?
How to delete existing triggers using "drop trigger"?
Define Business Edition in SQL Azure?
Relational calculus is what type of language?
What is the meaning of resultset type_scroll_insensitive?
can SSRS reports Cache results?
How to get all stored procedures in sql server?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Do you know what are the properties of the relational tables?
What are basics of policy management?
What is the most common type of join?
List all types of constraints in sql server?
How can I track the changes or identify the latest insert-update-delete from a table?
