Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54079 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / rima
NO.If the table has the primary key column, then by default
it will have a clustered index on that primary key
cloumn.So if you want to create a clustered index on non
primary key column then you have to create it before
setting a column as the primary key column or u have to
delete the clustered Primary key columns index to create a
new one.but it is recommended to have a clustered index on
primary key column.
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
Difference between Logical Page and Physical Page in SSRS.
Explain having clause?
What is a synonym for manipulation?
What is the difference between Triggers and Stored Procedure?
Does full backup break log chain?
What is 'Join' and explain its various types.
What are the different types of columns types constraints in the sql server?
Explain throw statement in sql server 2008?
What is de-normalization in sql database administration? Give examples?
What is a rollup clause?
how would you store your query in an SSRS report or a Database server?
What are the advantages of log shipping?
How fixed length strings are truncated and padded?
What is the recovery model?
How to enter date and time literals in ms sql server?
