Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54115 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 recovery models for a database?
How do I view views in sql server?
What is rolap and its advantage? : sql server analysis services, ssas
what are the disadvantages of cursors? : Sql server database administration
what data regions are and what are the different data regions?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How do you run a trace?
Explain transaction server explicit transaction?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Can you name a few encryption mechanisms in sql server?
Explain the truncate command? : SQL Server Architecture
What are the disadvantages of using the stored procedures?
How to locate and take substrings with charindex() and substring() functions?
What is the difference between a clustered index and a non-clustered index?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
