Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why Adding "+0" Make A Query Run Faster
"Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message news:<aergf6$91iti$1_at_ID-127142.news.dfncis.de>...
> Hi,
>
> adding 0 to column means disabling indexes on that column in RBO
> environment.
> That's why you got different explain plans.
No that can't be a reason, because:
The change between two of them is that CBO decided to use NESTED LOOP using some partitions instead of HASH JOIN through all partitions.
-- _________________________________________ Dusan Bolek, Ing. Oracle team leader Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we can call it an overture to bankruptcy) on that server. I'm still using this email to prevent SPAM. Maybe one day I will change it and have a proper mail even for news, but right now I can be reached by this email.Received on Thu Jun 20 2002 - 02:35:57 CDT