Indexing Tables

[craig]

Hi

Can someone please explain this to me (or point me in the
right direction), as I didn't find help all that helpful!,
I would like to know the advantages (and disadvantages) of
indexing tables. and what impact indexing could have if
indexing data that are already in tables - could you lose
data ? etc. any help you be greatly appreciated !

Thanks
Craig

 

[Van T. Dinh]

Access create indices to retrieve Records quickly by using indices to get to
the required Records quickly in Select queries, Seek Method and I think Find
.... Method. I think the indexing is generally done during idle time (that
why Access97 always show Access using 100% of CPU time), indexing should
affect your database operation much and indices really help in retrieving
Records.

That's said, you should really use indices when necessary and appropriate,
e.g. I don't put indexing on Double, Single, etc ...

I think there are limits on the number of Fields in a Index (10?) and the
number of indices on a Table (32?).

No, I never lost data due to indexing. Corruptions do occur but I couldn't
say that indexing is the culprit.