Re: Another SQL question

(Srinivasa Kunamneni) writes:
>Amine Y. Tarhini wrote:

   [Original post deleted for brevity]

>Try changing the order in from clause:
> from inventory, cars, yr_model
>( try to keep number of records to min from the driving table..the table far
> away from "FROM" clause.. yr_model)
>
>Hope it helps..
>
  I tried it and it helped a little bit. I am told that because of the   outer join I should not expect much more in the way of performance. This   will do for now anyway. Thanks for the help.

-- 
Amine.
atarhini_at_ringer.cs.utsa.edu

The above views are mine only ... etc. etc.