Oracle 8i standard vs enterprise edition

Honza Pazdziora adelton na informatics.muni.cz
Úterý Květen 8 15:21:56 CEST 2001


On Tue, May 08, 2001 at 03:17:50PM +0200, Petr Snajdr wrote:
> 
> zda se, ze ... asi takto:
> 
> 8.1.7 EE/Sparc/Solaris
> 
> Execution Plan
> ----------------------------------------------------------
>    0      SELECT STATEMENT Optimizer=CHOOSE
>    1    0   VIEW
>    2    1     COUNT
>    3    2       VIEW
>    4    3         SORT (ORDER BY)
>    5    4           NESTED LOOPS
>    6    5             NESTED LOOPS
>    7    6               TABLE ACCESS (FULL) OF 'CAMPAIGN'
>    8    6               TABLE ACCESS (BY INDEX ROWID) OF 'SPOT'
>    9    8                 INDEX (RANGE SCAN) OF 'IDX_SPOT_CAMPAIGN_ID'
>            (NON-UNIQUE)
> 
>   10    5             TABLE ACCESS (BY INDEX ROWID) OF 'PACK'
>   11   10               INDEX (UNIQUE SCAN) OF 'PACK_PK_ID' (UNIQUE)
> 
> 
> 
> 8.1.6 SE/Intel/Linux
> 
> Execution Plan
> ----------------------------------------------------------
>    0      SELECT STATEMENT Optimizer=CHOOSE (Cost=472 Card=6238 Bytes=
>           1915066)
> 
>    1    0   VIEW (Cost=472 Card=6238 Bytes=1915066)
>    2    1     COUNT
>    3    2       VIEW (Cost=472 Card=6238 Bytes=1833972)
>    4    3         SORT (ORDER BY) (Cost=472 Card=6238 Bytes=555182)

Cili prvni vec, bych v tom 8.1.7 nageneroval statistiky. Tak tam i ten
choose pujde jako cost a nikoli jako rule (coz zda se je problem, ze
mu nested loops pro tato data vychazi hure nez hash join).

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
   .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, DBD::XBase.
------------------------------------------------------------------------


Další informace o konferenci Test