Indexing of fields

Results 1 to 2 of 2

Thread: Indexing of fields

  1. #1
    Join Date
    Dec 1969

    Default Indexing of fields

    Should I always index fields that are used as part of a search criteria? Or should I only really index fields that are used frequently for searching? Are there any rules regarding this????<BR><BR><BR>If it makes a difference I&#039m using Access 97.<BR><BR>TIA<BR>Paul

  2. #2
    Join Date
    Dec 1969

    Default RE: Indexing of fields

    ineding a field wil speed up selects by that field, so index commonly used fields. a decent database design will include these considerations. consider buying SQL Unleashed by SAMS publishing - it&#039ll help a lot<BR><BR>j

Posting Permissions

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