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
- 7858 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 are different type of Collation Sensitivity?
What is sql server profiler?
When you should use a low fill factor?
Other than truncate statement, which other command can by-pass the trigger on the tables?
How you can move data or databases between servers and databases in sql server?
Where are sql server usernames and passwords stored in the sql server?
What is an indice?
What is the difference between for trigger and after trigger?
What is it’s similarity with sql server?
What do you understand by hotfixes and patches in sql server?
What are “lost updates”?
Do you know hot add cpu in sql server 2008?
What are trace flags and mention a few common trace flags used with sql server?
How do I schedule a sql server profiler trace?
plss anybody specify tha constrian management system in dbms
