WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
- 8 Answers
- 20571 Views
- I also Faced
- E-Mail Answers
Answer Posted / muthu
Clustered index based on Primary Key. So if we create a PK,
automatically Clustered Index will be created. So only one
CI available for a table.
| Is This Answer Correct ? | 10 Yes | 14 No |
Post New Answer View All Answers
What do you understand by physical_only option in dbcc checkdb?
How to perform key word search in tables?
Differentiate between truncate vs delete in mssql?
Name few of the dcl commands in sql?
How to perform backup for certificates in sql server? : sql server security
What is side by side migration in sql server?
What function does a database engine serve in the sql server?
What is database dimension? : sql server analysis services, ssas
Characterize join and name diverse sorts of joins?
Scalability, Availability, Integration with internet, etc.)?
What is dirty page?
Would you store your query in a ssrs report or a database server? State the reason why?
What are commonly used mssql functions in php?
What is ms sql server service broker?
How to insert stored procedure result into temporary table?
