Post reply

How to make a query run faster

  • May 9, 2007 at 1:18 am

    #177946

    Hi,

    I am opening a query in Access which has two linked sql tables but it takes to long to open. Can I choose a method (ADO) opening that query? If not, is there a way to speed up the process?

    thanks

  • May 10, 2007 at 1:25 pm

    #705639

    What is the type of query... is it just a select or is it an update?

    Thanks,

    -TB

  • May 10, 2007 at 11:54 pm

    #705725

    Hi,

    thanks for your reply. It is a select query

  • May 11, 2007 at 9:01 am

    #705847

    OK if you are only doing a select why not use a SQL View to create the join you need and then link to the view instead of the two tables. SQL Server should take care of all the overhead in joining the tables for you and it would be much faster.

    HTH

    -TB

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply