Re: how to hint on order of execution

From: Kenny Yu <kyu_at_biodiscovery.com>
Date: Thu, 20 Feb 2003 14:46:01 -0800
Message-ID: <v5amh220q02055@corp.supernews.com>

Thanks, Anurag. ORDERED hint works great in my case. The order of the where-clauses seems immaterial; Is this always true? Does the order of the from-list matter without the ORDERED hint?

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:v55vnk5lq3dgab_at_corp.supernews.com... ORDERED hint is probably what you are looking for. orders the table join from left to right (in the from clause).

Anurag

"Kenny Yu" <kyu_at_biodiscovery.com> wrote in message news:v55l0psm0kd5d9_at_corp.supernews.com...
> The query hints (use_nl, index etc.) all relate to the methods to use. How
> do I get the optimizer to start with the tables that know are very small?
> that is, to hint on the order of joining.
>
> Kenny
>
>
Received on Thu Feb 20 2003 - 16:46:01 CST