On Mon, 22 Mar 2010 15:46:01 -0700, QB wrote:

Is there a drawback to indexing fields? What about indexing fields that
aren't used in queries as criteria (over-indexing)? Does indexing add load
to database processing (I'm assuming so or else you would have told me to
index to my heart's content :-) )?

Indexes speed data retrieval but they *slow* data insertion or updating (the
program must update not only the table but all the indexes that are touched by
a change of the data); there is also a limit of 32 indexes on any one table.
In addition indexes do take up room in the database, counting toward the
2GByte limit on the size of the database.

--

John W. Vinson [MVP]