Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 55382 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / gunjan sapra
no,we can't create clustered index on non primary key just
because of the simple reason that in clstered
index,physical sorting is done while in non primary key
there might be hundreds of duplicate entries. so, if we
create clusterd index on non primary key it will get
confused and then error.
| Is This Answer Correct ? | 34 Yes | 49 No |
Post New Answer View All Answers
What is acid mean in sql server?
What is sql server replication? : sql server replication
Tell me what is the difference between locking and multi-versioning?
What is the purpose of a table?
What are relationships and mention different types of relationships in the dbms
What is the difference between substr and charindex in the sql server?
What are the different methods available under sqlcommand class to access the data?
How to create an inline table-valued function?
explain different levels of normalization? : Sql server database administration
Explain system scalar functions?
How to throw custom exception in Stored Procedure?
What is use of except clause? How does it differ from not in clause?
What are views used for?
What is a field in a table?
Explain primary key?
