|
[oracle-l]
||
[Date Prev]
[10-2004 Date Index]
[Date Next]
||
[Thread Prev]
[10-2004 Thread Index]
[Thread Next]
Re: Optimizer Choices - Part Two
- From: ryan_gaffuri@xxxxxxxxxxx
- To: FREEMANR@xxxxxxxx, "''oracle-l@xxxxxxxxxxxxx ' '" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 01 Oct 2004 19:11:01 +0000
does oracle use something akin to 'estimated LIOs' in order to estimate cost?
Mogens wrote in the oak table book that LIOs do not necessarily translate into
CPU. so more LIOs does not necessarily mean more CPU usage. There isn't enough
granularity with the different types of LIOs to know which LIOs result in more
CPU usage than others.
also, the CBO sometimes is just wrong even with cpu costing. The biggest
problems I have had is when i have a table with both Bitmaps and Btree indexes.
Oracle occasionally chooses a bitmap when a Btree is more appropriate.
-------------- Original message --------------
> Good afternoon folks...
>
> Continuing our discussion on the optimizer from yesterday. To review:
>
> I have the following statement:
>
> select a.empid, a.ename, b.dname
> from emp a, dept b
> where a.deptno=b.deptno
> and a.empid < 1000
>
--
http://www.freelists.org/webpage/oracle-l
|
|
