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
- 21810 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by the denormalisation?
What are the purposes of floor and sign functions?
Does table partitioning improve performance?
What is sql language?
How to create a dynamic cursor with the dynamic option?
Does a specific recovery model need to be used for a replicated database? : sql server replication
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is the cpu pressure?
What is sql injection and why is it a problem? : sql server security
Does hive support indexing?
What is the difference between grant and with grant while giving permissions to the user?
How would we use distinct statement? What is its use?
What is a database table?
what is hash nonclustered index
