Getting costs for hypothetical query plans
From: Tom Anderson <twic_at_urchin.earth.li>
Date: Fri, 25 Feb 2011 16:58:59 +0000
Message-ID: <alpine.DEB.1.10.1102251657340.16341_at_urchin.earth.li>
Hi,
Date: Fri, 25 Feb 2011 16:58:59 +0000
Message-ID: <alpine.DEB.1.10.1102251657340.16341_at_urchin.earth.li>
Hi,
We have a query which has a surprising plan. I assume Oracle considered the right plan, but rejected it. Is there any way to tell it that plan, and have it tell me the cost breakdown of it? That would really help me figure out what's going wrong.
Thanks,
tom
-- Who would you help in a fight, Peter van der Linden or Bill Gates?Received on Fri Feb 25 2011 - 10:58:59 CST