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
- 21532 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is public role in sql server?
What are window functions in sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to use linked server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
Do you know what is similarity and difference between truncate and delete in sql?
What are the advantages of using third-party tools?
Explain the cursor lock types?
Do you know how to store and query spatial data?
what is the sql equivaent of the dataset relation object ?
Which joins are sql server default?
What is mean by dml?
What is the use of @@spid?
Why and when do stored procedure recompile?
What is sql injection? How to protect against sql injection attack?
