Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2006
    Posts
    35

    Unanswered: Need basic indexing advice

    Should I index the master table ID autonumber field in the detail table?

  2. #2
    Join Date
    Mar 2007
    Posts
    277
    Are you asking if you should index the ForeignKey field in the Detail table? Indexing helps on searching, so if you are doing a .FindFirst then sure. Generally it is not necessary and only slows things down when updating because of maintaining the index.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I usually index any fields I'm doing searches on. I've found you can index many fields in a table but having too many can affect performance. I'm not sure but I think there's an equation for indexing somewhere.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I index all FK's.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •