should i index linked fields

[WindAndWaves]

Should I index fields that are linked to another table???

Note:
- all links are ref. enforced

- all links are one-to-many

- I have some links of type A
small list with a byte ID (of which the size is only one byte) links to
many items in a large lists (e.g. one country to many contacts)

- I have some links of type B
large lists with an Long Integer (autonumber) ID link to another large
lists (e.g. one client to several contacts)

Thank you in advance - Nicolaas

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 06/06/2004

[Tom van Stiphout]

On Wed, 9 Jun 2004 14:11:13 +1200, "WindAndWaves" <ac****@ngaru.com>
wrote:

No.
Access already did this for you, behind hte scenes.
Think if it didn't; how slow some apps would be, and how poorly Access
would show in comparative reviews.

-Tom.

Should I index fields that are linked to another table???

Note:
- all links are ref. enforced

- all links are one-to-many

- I have some links of type A
small list with a byte ID (of which the size is only one byte) links to
many items in a large lists (e.g. one country to many contacts)

- I have some links of type B
large lists with an Long Integer (autonumber) ID link to another large
lists (e.g. one client to several contacts)

Thank you in advance - Nicolaas

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 06/06/2004

[WindAndWaves]

Dear Tom,

Thank you for your reply.

When you say 'behind the scenes' does that mean that it the index is not
listed when you open the index dialog in the table design view or that the
index can not be deleted/added from VBA?

A while ago, you see, I went through my database and deleted all the
indexes, except the ones I deemed imperative. I left out the ones described
in the original post, because I was not sure if this was necessary.

Thank you.

- Nicolaas


---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 06/06/2004

[Tom van Stiphout]

On Wed, 9 Jun 2004 14:29:59 +1200, "WindAndWaves" <ac****@ngaru.com>
wrote:

They are not listed in the Indexes window, but they are in the Indexes
collection.

Doei,

-Tom.

Dear Tom,

Thank you for your reply.

When you say 'behind the scenes' does that mean that it the index is not
listed when you open the index dialog in the table design view or that the
index can not be deleted/added from VBA?

A while ago, you see, I went through my database and deleted all the
indexes, except the ones I deemed imperative. I left out the ones described
in the original post, because I was not sure if this was necessary.

Thank you.

- Nicolaas


---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 06/06/2004

[WindAndWaves]

So, when I ran a function that deleted all indexes out of the database, they
would have been deleted also???
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 06/06/2004

[Tom van Stiphout]

On Wed, 9 Jun 2004 16:05:04 +1200, "WindAndWaves" <ac****@ngaru.com>
wrote:

Why not take 10 seconds and confirm that for yourself rather than
asking:
?currentdb.tabledefs("my_table").Indexes.Count

-Tom.

So, when I ran a function that deleted all indexes out of the database, they
would have been deleted also???
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 06/06/2004

[WindAndWaves]

Well, Tom, I did check that. Thank you for that.

It is very interesting. Because there is always one more index then there
is listed in the index dialog form that you can open in the design table
view.

Spooky! Would this be the linked one?

Should I conclude that it is not necessary to make indexes for linked
fields, because Access already does this by itself?


---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.701 / Virus Database: 458 - Release Date: 07/06/2004