Skip to Content
0
Former Member
Oct 30, 2009 at 09:53 AM

Indexes / Keys etc

10 Views

Hi all,

I am just wondering if these thoughts are true.....

a. Accessing the database by KEY is the fastest (quicker than INDEX)?

b. Each table can have a number of indexes which in turn comprises a number of fields...

i. If you use all fields in the index then the INDEX will be used resulting in better performance?

ii. If you use the INDEX and also use other fields is the INDEX still used?

iii. If you use multiple fields which cover 2 INDEXs will performance be even quicker?

Many thanks.