WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
- 8 Answers
- 19784 Views
- I also Faced
- E-Mail Answers
Answer Posted / samrat sen
Clustered Index creation does not depend upon primary key ,
it can be created on any column, but the write answer is
whenever we create clustered index on a table it physically
sorts the column values, so another clustered index is not
possible.
| Is This Answer Correct ? | 14 Yes | 10 No |
Post New Answer View All Answers
What happens if an integer is too big for int date type?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How to resolve the orphan use problem? : sql server security
How to replace given values with null using nullif()?
What is the stuff and how does it differ from the replace function?
What is the sql profiler?
Explain the steps needed to create a scheduled job?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
How to remove duplicate rows from table?
Can we take the full database backup in log shipping?
Explain what are page splits? : SQL Server Architecture
What is the difference between DATETIME2 and DATETIME?
Differentiate between SQL and ORACLE joins and write their syntax.
How to select an exiting database using mssql_select_db()?
What is abstracting periodical?
