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
- 22047 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 are approximate numeric data types in ms sql server?
How use inner join in sql server?
Does table partitioning improve performance?
Define msdb database?
How to create function with parameter in sql server?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Characterize join and name diverse sorts of joins?
What is the appropriate number of test cases that you can write on a database?
What are the components of dbms?
Describe triggers features and limitations?
Please tell me some knowledge about Clustering and how to add clustering?
Does view occupy space?
-
Oracle (3253) - 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)
