Re: Plan change after moving to 10g 10.2.0.3

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Thu, 18 Dec 2008 07:57:30 +0000 (GMT)
Message-ID: <332896.74724.qm@web27407.mail.ukl.yahoo.com>


Hi

I am attaching the plan good and the bad plans. First one using NL and a index is a good plan and the one using has join and a full table join is bad

regards
Hrishy


--
http://www.freelists.org/webpage/oracle-l


Received on Thu Dec 18 2008 - 01:57:30 CST

Original text of this message