Interested to Buy Any Domain ? << Click Here >> for more details...
What are the type of Indexes? which one is best, why?
- 6 Answers
- 9888 Views
- I also Faced
- E-Mail Answers
Answer Posted / jeff jordan
1) Clustered Index
2) Non-Clustered Index
I'm assuming by "which one is best" we mean which has the
faster look ups. This would be the clustered index since it
is the physical ordering of the rows and the non-clustered
index is like a lookup table. With the clustered index one
you've found the index you've found your row...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to create a user name in a database?
How can you check the version of sql server?
What is lock escalation? : sql server database administration
How to grant a permission in ms sql server using "grant execute" statements?
What is the stored procedure?
When would you use it?
What is 3nf normalization form?
What are the joins in sql server? : sql server database administration
What are rows and columns?
Do you know what are the reporting services components?
What is not null constraint?
How to update muliple row in single query?
What is catalog views?
Explain the creation and execution of a user-defined function in the sql server?
What are the types of stored procedures in an sql server?
