What are the type of Indexes? which one is best, why?
- 6 Answers
- 7916 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
Explain the properties of a relational table?
What is exporting and importing utility?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
Which rendering formats are affected by the pagesize properties?
Does index speed up select statements?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Explain linked server in sql?
What is sqlservr.exe - process - sql server (sqlex?press)?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is schemabinding a view?
explain different types of constraints? : Sql server database administration
Explain sql server service broker?
Explain partitioned view?
How to restore performance issues and how to check?
What is the purpose of sql profiler in sql server?
