Can we create clustered index on non primary key column
Answer Posted / surya prakash
Finally, i want to conclude by saying.
1. We can create Clustered Index on Non-Primary Key Columns
and this table should not contain any other column with
Primary Key.
2. It is recommended that we create Clustered Indexing on
Primary Key Columns
Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
How to remove duplicate rows from table?
What are different types of join?
What are the differences between web role and worker role?
Where are sql server user names and passwords stored in sql server?
What is for xml in sql server?
What happens if null values are involved in arithmetic operations?
How to recover from sql injection? : sql server security
What are the three different part of rdl file explain them?
Explain sql server service broker?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
How to execute a stored procedure in ms sql server?
How to send email from database?
What language is sql server written in?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is the difference between row_number and dense_rank?