Indexed Fields

  • Thread starter Thread starter Ngan Bui
  • Start date Start date
N

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?
 
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?
|
 
Back
Top