Re: Optimizer Hints and Explain Plan

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Tue, 20 Oct 2009 04:51:59 -0700 (PDT)
Message-ID: <719fabd0-3ee6-4197-a063-17d3c7068722_at_o21g2000vbl.googlegroups.com>

On Oct 20, 2:03 am, DeB <debashish.majum..._at_gmail.com> wrote:

snip

> Hi All,
>    I'm using /* no_cpu_costing */ hint in my select statements while
> generating the explain plan. Is it a good idea to use it while
> analyzing the Explain Plan output? Please suggest.
>
> --
> Thanks
> DeB

You have a comment in your select statement not a hint.

No it's not a good idea don't you want to use the real explain plan?

Try looking at structured data or optimizer magic blogs as well as Tanel Poders site for some better ideas. Both the optimizer magic and structured data as done by Oracle Corp experts and Tanel has a whole library of useful scripts. Received on Tue Oct 20 2009 - 06:51:59 CDT