Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2016
    Posts
    1

    Unanswered: Query runs fast when criteria is set, runs slow when joined with local table

    I have a query that runs quickly (less than a second) when criteria is provided. However, instead of using criteria, I did an inner join to another query (that utilizes grouping). This slowed it down significantly and I thought it was because I'm using grouping. So instead, I changed the query with grouping to a make table and then on the second query I joined to the fields on the local table. This, however didn't seem to help. I'm thinking the problem is that referencing a local table is causing the query to run locally on my machine and not on the server. I'd appreciate any advice on how to make this run faster. I have to think this is a pretty common occurrence. Thanks!

    BROMETHIOUS

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Are the tables indexed?

Posting Permissions

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