Re: Optimizer Plan's Cost
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: fahd-m@xxxxxxxxxxx
- Date: Tue, 26 Oct 2004 10:22:04 +0100
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@xxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
