Can we create clustered index on non primary key column
Answer Posted / durgaprasad
no its not possible to place clustered index on non key
column once the table contains any one key column, bcoz key
column itself contains one clustered index based on that
data sorted in ascending order.if u place one more
clustered index how it is possible to arrange the data in
soreted order.
Is This Answer Correct ? | 15 Yes | 29 No |
Post New Answer View All Answers
What are the steps you can take to avoid “deadlocks”?
Do you know clustered and non-clustered index?
What is wide table?
Can I disable or restrict ssrs export formats (rendering formats)?
What are wait types?
Explain forward - only cursors?
What happens on checkpoint?
What is a file group?
When do you think a developer should use sql server-based cursors?
Is candidate a key?
What is openrowset sql server?
What function does a database engine serve in the sql server?
Do you know what is a linked server in sql server?
Do you know the cursor optimization tips?
Can we join two tables without primary key?