Re: Optimizer Plan's Cost

AFAIK.. The Cost is Aggreagted from the First Step Onwards to the Last One. So the First Line In your plan is the last step and that is the Cost of the Plan.

HTH Cheers
Ganesh

On Tue, 26 Oct 2004 14:10:19 +0500, fahd mirza <fahd-m_at_aero.com.pk> wrote:
> Hi Listers,
> I have one doubt regarding optimizer plan. would u please rectify them.
> Lets say I have a query like this
>
> select * from foo where foo100=:b1 order by foodate;
>
> The plan might be like this
>
> Operation Step# Cost
> Select Statement 4 24
> Sort (order by) 3 24
> foo table access 2 22
> fooidx index (range scan) 1 1
>
> Now what would be the cost of this plan. would it be the aggregate of all four operations that is 24+24+22+1=71 or would it be just of first operation i.e. 24 or what? Please clarify this. thanks
> regards,
> Fahd
>
> --
> http://www.freelists.org/webpage/oracle-l
>

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