Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54910 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
How can you stop stored procedures from recompiling?
How to delete multiple rows with one delete statement in ms sql server?
What are the functions in sql server?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Tell me what is difference between view and materialized view?
If the job running very slow what is the action you do
List the different index configurations possible for a table?
What is a trigger and its types?
How many types of subqueries are there in sql server?
What is normalization of database? What are its benefits?
What are the differences between web role and worker role?
What are the different types of sub-queries?
What are cursors and when they are useful?
What is the difference between web edition and business edition?
what are candidate key, alternate key and composite key? : Sql server database administration
