Interested to Buy Any Domain ? << Click Here >> for more details...
In clustered and non clustered indexes which one is faster
while executing a query ?
- 1 Answers
- 7968 Views
- I also Faced
- E-Mail Answers
Answer Posted / arunyadav007
Clustered Index.
Because the leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
In case of non-clustered index the leaf level is actually a
pointer to the data in rows. The data is stored in one
place, the index in another, with pointers to the storage
location of the data. The items in the index are stored in
the order of the index key values, but the information in
the table is stored in a different order.
Thanks,
Arun
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What is updatable resultset?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Explain raiserror in sql server?
What are the advantages of using a stored procedure?
What is 'write-ahead log' in sql server 2000 ?
What is change data capture (cdc) feature?
How to skip remaining statements in a loop block using continue statements?
What is a functions and types in sql server?
What is a recursive stored procedure in sql server?
Who is the owner of a schema in ms sql server?
How to create an inline table-valued function?
What is oltp (online transaction processing)?
What is a full text index?
What is the difference between a "where" clause and a "having" clause?
How to create function with parameter in sql server?
