WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
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
How to set database to be read_only in ms sql server?
How is foreign key related to primary key?
What are the kinds of subquery?
What is the process of normalization?
What is the importance of a recovery model?
What is SQL Azure Federations?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Why use “nolock” in sql server?
Can we use pragma autonomous_transaction in trigger?
Can you get second highest salary from the table?
What is primary key index?
Define tempdb database?
What is an indexing technique?
What is the difference between a function and a stored procedure?
Explain isolation levels that sql server supports?