In clustered and non clustered indexes which one is faster
while executing a query ?
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 are the purposes of floor and sign functions?
Do you know query execution plan?
What is dbcc? Give few examples.
What is the default value of an integer data type in sql server 2005?
What are the extra roles available in msdb? : sql server security
What is a cursor, index in sql?
When to use null data driven subscription?
How does normalization work?
How to create percentile function?
What is the difference between varchar and varchar types?
what's the difference between a primary key and a unique key? : Sql server database administration
How to transfer an existing table from one schema to another schema in ms sql server?
can a table be moved to different filegroup? : Sql server administration
explain databases and sql server databases architecture? : Sql server database administration
What is normalization? Describe its different types.