Results 1 to 2 of 2

Thread: speeding up my search by using index's?

  1. 09-18-2003, 11:33 AM #1
    Zodiacal
    Zodiacal is offline Registered User
    Join Date
    Sep 2003
    Posts
    4

    speeding up my search by using index's?

    would makeing my first and last name fileds search faster by putting an
    index on them. there is 30k records so far
    Reply With Quote Reply With Quote
  2. 09-19-2003, 05:44 AM #2
    KnooKie
    KnooKie is offline Registered User
    Join Date
    Jan 2003
    Location
    UK
    Posts
    277
    yes it would........
    generally speaking any field you have in the WHERE part of a query will run faster if it is indexed.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules