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
- 21537 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / honnur swamy
A clustered index sorts and stores the data rows in the
table based on the index key values. Therefore only one
clustered index can be created on each table because the
data rows themselves can only be sorted in one order.
| Is This Answer Correct ? | 33 Yes | 3 No |
Answer / 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 |
Answer / abhijit
A clustered index sorts and stores the data rows in the
table based on the index key values. Therefore only one
clustered index can be created on each table because the
data rows themselves can only be sorted in one order.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / shailesh arban
Because cluster index sort data in table based on key value that is you primary key value and primary key values are unique in table therefore cluster index only one on table.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / jai
A clustered index sorts and stores the data rows in the table based on the index key values. Therefore only one clustered index can be created on each table because the data rows themselves can only be sorted in one order.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / samrat sen
yes,you can only create one clustered index on a table.
| Is This Answer Correct ? | 10 Yes | 12 No |
Answer / 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 |
Answer / raju.r
we can create ony ONE clustered index per table .. for Non-
clusrtered index we can create 249 ...
| Is This Answer Correct ? | 4 Yes | 11 No |
What is table join?
What are sp_configure commands and set commands?
how to define testing of network layers? : Sql server database administration
What is built-in function?
What is a primary key?
Define Unique Key?
What do you know about normalization and de- normalization?
What is the difference between Drop and Truncate
Which command using Query Analyzer will give you the version of SQL server and operating system?
what r steps to we need to fallow b4 kill the process?
How do I port a number to sql server?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
