By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,496 Members | 1,528 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,496 IT Pros & Developers. It's quick & easy.

should i index linked fields

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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


Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
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


Nov 13 '05 #4

P: n/a
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
Nov 13 '05 #5

P: n/a
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


Nov 13 '05 #6

P: n/a
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
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.