Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54152 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
How to generate random numbers with the rand() function in ms sql server?
What are three major types of constraints?
What is the impact on other user sessions when creating indexes?
What is an indexing technique?
What is the difference between writing data to mirrored drives versus raid5 drives
What command would you use to add a column to a table in sql server?
Explain forward - only cursors?
Explain primary key in sql server?
What are the different types of triggers in SQL SERVER?
How to run sql server 2005 books online on your local system?
How do I open a .db file?
What is the difference between drop table and truncate table?
How do I port a number to sql server?
Can you tell me about the concept of ER diagrams?
Can two tables share the same primary key?
