Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    34

    Unanswered: Performance of a query

    Hi Everyone,

    Is there a way to enhance the speed of a query on a rather large table?

    I have a table of almost 2 million recs and I am doing a name search on the full or partial name but it seems to be taking a very long time.

    Any ideas?

    Schoon

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: Performance of a query

    Originally posted by Schoon Dog
    Hi Everyone,

    Is there a way to enhance the speed of a query on a rather large table?

    I have a table of almost 2 million recs and I am doing a name search on the full or partial name but it seems to be taking a very long time.

    Any ideas?

    Schoon

    You can index the column...but if you are doing a partial look up i dont think it will look at the index, so indexing may only help on the full name search.

    BTW are there any joins in the query, because joins do slow down a query.

    Regards
    Jim

Posting Permissions

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