Indexed Fields

[Ngan Bui]

Can someone give me a quick overview of when to index a
field and which field to index?

I read that indexing too much could slow the db leading to
corruption...but having enough indexes will speed up
searches and such.

By default, anything that has ID;key;code;num in the field
name is indexed. Most of my primary keys and foreign keys
ends in "ID" so they get indexed automatically.

When would I index a field? I don't have alot of search
forms. Is it ok to just have the primary key be indexed
on all of my tables?

 

[Rita Nikas [MSFT]]

Hi Ngan.

In addition to John's feedback, you might also want to review this
Microsoft Knowledge Base Article for more information on optimizing queries
which includes some commentary on indexing:

209126
ACC2000: How to Optimize Queries in Microsoft Access 2000
http://support.microsoft.com/?kbid=209126

Sincerely,

Rita Nikas, MCSE MCDBA
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Subject: Indexed Fields
| Date: Tue, 8 Jul 2003 08:29:04 -0700
|
| Can someone give me a quick overview of when to index a
| field and which field to index?
|
| I read that indexing too much could slow the db leading to
| corruption...but having enough indexes will speed up
| searches and such.
|
| By default, anything that has ID;key;code;num in the field
| name is indexed. Most of my primary keys and foreign keys
| ends in "ID" so they get indexed automatically.
|
| When would I index a field? I don't have alot of search
| forms. Is it ok to just have the primary key be indexed
| on all of my tables?
|