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
- 22054 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
How to find the second highest salary of an employee?
Name three of the features managed by the surface area configuration tool? : sql server security
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Explain the cursor lock types?
How much does sql server 2016 cost?
What are views used for?
How can you hide the sql server instances?
What is open database communication (odbc)?
Disadvantages of the indexes?
What does the not null constraint do?
What is buffer cash and log cache in sql server?
Explain the purpose of indexes?
What do you understand by the denormalisation?
What is inner join? Explain with an example?
What is GUID in sql server?
