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
- 21796 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 |
A trigger can reference objects outside the current database? State true or false.
What is difference between oltp and olap?
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...
how would you troubleshoot blocking? : Sql server database administration
What is the difference between NOROW and LOCKROW?
0 Answers Accenture, Honeywell, Satyam,
What are orphan records?
i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?
How many types of keys are there?
What is the default value of CHAR type?
How to rename an existing column with sql server management studio?
What are examples of triggers?
Can group by be used without aggregate functions?
-
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)
