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?