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


Please Help Members By Posting Answers For Below Questions

What do you mean by an execution plan? Why is it used? How would you view it?

749


What is the difference between char and varchar2 datatype in sql?

800


Explain security with sql azure?

173


How to loop through result set objects using odbc_fetch_row()?

715


What is the contrast amongst drop and truncate?

803


What is “asynchronous” communication in sql server service broker?

762


Is sql server is free?

753


What do you need to connect php to sql server?

817


what is the difference between count(*) and count(1) ?

859


what is the main function of a query parameter?

126


Can we call future method from queueable?

787


What functions can a view be used to performed?

837


Does the order of columns in update statements matter?

705


What command is used to create a database in the sql server and how?

899


What is normalization? Explain different forms of normalization?

812