![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
I have inherited a *.mdb with many tables and many relationships between
them. I've also noticed that there are not a lot of indexed fields. As a newbie-ish, I suspect that any field that is related to another field in different table ought to be indexed. Is this a sound approach? thanks in advance, mark |
#2
|
|||
|
|||
![]()
On Tue, 11 Nov 2008 23:06:32 -0500, "Mark Kubicki"
wrote: I have inherited a *.mdb with many tables and many relationships between them. I've also noticed that there are not a lot of indexed fields. As a newbie-ish, I suspect that any field that is related to another field in different table ought to be indexed. Is this a sound approach? thanks in advance, mark A relationship defined in the Relationships window with referential integrity enforced *will* automatically create indexes on the joining fields. You don't need to (and indeed shouldn't) create duplicate indexes. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|