|
| 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
November 12th, 2008, 04:06 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
indexing: how much is enough
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
November 12th, 2008, 06:24 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
indexing: how much is enough
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 | |
|
|
Linear Mode
