Re: Request in 9i slower than in 8i ...

"zeb" <spam_at_nowhere.com> wrote:
> Hi,
>
> For a migration from 8i to 9i
> a request is slower in 9i than 8i ( x5 )
> the excution plans are different
> why ? and how can I speed my request in 9i as it was in 8i ??

It looks like the dstmp.stock_ims table is 20 times bigger in 9i than it is in 8i. Or at least it looks like that the stats think it is.

>
> 8i
> Execution Plan
> ----------------------------------------------------------
> 3 2 INDEX (FAST FULL SCAN) OF 'STOCK_IMS_PK' (UNIQUE) (Cos
> t=486 Card=51086 Bytes=715204)
....
> 9i
> Execution Plan
> ----------------------------------------------------------
> 3 2 INDEX (FAST FULL SCAN) OF 'STOCK_IMS_PK' (UNIQUE) (Cos
> t=811 Card=1108830 Bytes=18850110)

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB