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 Databases