Optimizer Plan's Cost
- From: "fahd mirza" <fahd-m@xxxxxxxxxxx>
- To: "Active DBA" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Oct 2004 14:10:19 +0500
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
Other related posts:
