Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Location
    Atlanta, GA
    Posts
    211
    Provided Answers: 1

    Question Unanswered: Why is this query running so slow?

    I have an access query and it is running terribly slow and I can't figure out why. When i run the query in Toad (my SQL tool) it is instant, but in Access, it takes close to 15 minutes.

    The query looks up customer information based on their username. I also have the exact same query that looks up the info by email instead. This email version takes a couple seconds to run, but the username one takes 15 minutes. Both the email and the username (aka displayname) are varchar(100).

    Any idea why access is having a hard time with it?
    Attached Thumbnails Attached Thumbnails byemail.PNG   byusername.PNG  

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Do you have an index on MemberID in both tables and an index on Displayname?
    Have a nice day!

Posting Permissions

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