hpuxrac wrote:
> Personally, I advocate getting some more information before even
> thinking about adding a hint in some attempt to improve things.
>
> Changing the order of tables is a technique that is also often not what
> you want to advocate first, especially with only 3 tables ( apparently
> ) in the query.
>
> But what does that function do? Hmmm ...
Especially given that the optimizer will do that be default without
any human intervention.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Apr 19 2006 - 18:35:46 CDT
