query optimization

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If I have a query with multiple joins. How should I contract it for
the best performance: Start joining on the large table first and then
go down to the smaller tables or start with smaller tables and go up
to the largest ones.

Thank you,
T.
.

Relevant Pages

  • Re: Move Data into a blank field in a query
    ... The Contract rates can grow in 6th 7th etc but will be awhile. ... Here is my query and just a sample. ... Effective Dates so I dont confuse you more. ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.queries)
  • Re: How to archive records?
    ... Via a query I join three tables - Companytbl, ... The Contract has an assigned number which may only be used ... It sounds like you want a "flattened" set of related data. ... Microsoft IT Academy Program Mentor ...
    (microsoft.public.access.gettingstarted)
  • RE: Error 2465 getting recordset for subform
    ... just the rates for the contract and contractor numbers that the user enters. ... what you mean by predefined fields as opposed to user entered fields. ... form where you enter the values in the subform's query. ... Although I have read the threads about getting data into a subform, ...
    (microsoft.public.access.formscoding)
  • Re: Normalization
    ... this how i will generate my contract which is based on mail merge & in mail ... You CAN base a mailmerge on a query. ... just fetch customer no,name, date based on that i make a table & then a form ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Normalization
    ... this how i will generate my contract which is based on mail merge & in mail ... You CAN base a mailmerge on a query. ... just fetch customer no,name, date based on that i make a table & then a form ...
    (microsoft.public.access.tablesdbdesign)