Results 1 to 3 of 3
  1. #1
    Khalil Handal is offline Competent Performer
    Windows 10 Access 2003
    Join Date
    Jun 2016
    Posts
    237

    indexing

    Hi,


    A brief discretion for indexing.

    What is indexing?
    When should it be used?
    Which fields must be indexed? primary key, foreign keys, regular fields...

    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    a field you would use to join in queires:
    foreign keys , yes
    Primary key: N/A, not needed since its a primary key and already indexed.

    reg fields, no.

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    see this link about benefits of indexing

    https://www.access-programmers.co.uk...rmance.291268/

    to add to Ranmans comments I would also index fields regularly searched and/or sorted on

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Best Practice for FKs and indexing property
    By PrincessApril in forum Access
    Replies: 3
    Last Post: 02-26-2020, 04:31 AM
  2. Indexing Foreign Keys?
    By skidawgs in forum Access
    Replies: 6
    Last Post: 12-10-2019, 11:52 AM
  3. Indexing question
    By rjensen in forum Access
    Replies: 4
    Last Post: 01-21-2019, 12:10 PM
  4. Replies: 26
    Last Post: 07-16-2015, 09:19 PM
  5. Indexing question
    By Helystra in forum Database Design
    Replies: 8
    Last Post: 11-22-2013, 04:24 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums