Interested to Buy Any Domain ? << Click Here >> for more details...
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
- 8 Answers
- 22052 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
How to create dbo table in sql server?
What is inner join in sql server joins?
What are the restrictions applicable while creating views? : SQL Server Architecture
How do you make a trace?
How to create user messages with print statements in ms sql server?
What is #table in sql server?
What is xdr?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
explain the storage models of olap? : Sql server database administration
Name the different type of indexes in sql?
what is blocking? : Sql server database administration
What is a trigger? Why we need it?
what are the core components of SSRS?
What is checkpoint in sql server?
Why should you use or avoid select * statements?
