Interested to Buy Any Domain ? << Click Here >> for more details...
What are the type of Indexes? which one is best, why?
- 6 Answers
- 9710 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
What are the different authentication modes in sql server?
What is the difference between insensitive and scroll cursor?
What are built in functions?
What is a fan-out query in SQL Azure?
What are the basic features of a trigger in ms sql server?
Are all views updatable ?
How to create a view on an existing table in ms sql server?
what do you understand by change data capture?
What is wide table?
What do you mean by table and field in sql?
How to assign new column names in a view?
What are the different types of backups that exist?
What is exporting utility?
How to add the custom code in Report?
Name 3 ways to get an accurate count of the number of records in a table?
