Can we create clustered index on non primary key column
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
What do you mean by an execution plan? Why is it used? How would you view it?
What is the difference between char and varchar2 datatype in sql?
Explain security with sql azure?
How to loop through result set objects using odbc_fetch_row()?
What is the contrast amongst drop and truncate?
What is “asynchronous” communication in sql server service broker?
Is sql server is free?
What do you need to connect php to sql server?
what is the difference between count(*) and count(1) ?
what is the main function of a query parameter?
Can we call future method from queueable?
What functions can a view be used to performed?
Does the order of columns in update statements matter?
What command is used to create a database in the sql server and how?
What is normalization? Explain different forms of normalization?