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>
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-lReceived on Thu Dec 18 2008 - 01:57:30 CST
- text/plain attachment: 10.2.0.3.txt