Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54790 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
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is the function of sql server agent windows service?
How to connect to a sql server using odbc_connect()?
How do you delete a data source?
What is the stuff and how does it differ from the replace function?
What is the difference between value type and reference type?
Explain primary key in sql server?
how you can list all the tables in a database?
What is the difference between delete and truncate statements?
what is spatial nonclustered index
What language is sql server written in?
Why the trigger fires multiple times in single login?
What are subquery and its properties?
What happens if you delete a table that is used by a view?
How to set database to be read_only in ms sql server?
