Re: Slooow Select after Upgrade to 8.1.6 from 8.0.4

How fortunate you've moved to 8i.

Now you can avail yourself of all those lovely execution plan stability features available in 8i. Part of the rationale for the features is that 3rd party software, like Crystal Reports, does not allow for hints.

• Original Message ----- From: Joseph on Mediaone <josepha_at_mediaone.net> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, November 03, 2000 2:06 PM Subject: Slooow Select after Upgrade to 8.1.6 from 8.0.4

> Sun2.6; Oracle 8.0.4 partitioned and indexed table. Upgraded to 8.1.6
> through full export/import.
> Queries that returns 1200 rows ran before upgrade 5-7 sec. After upgrade ~40
> sec.
> When dropped index table from 8.1 performance restored. TKPROF shows that
> optimizer in 8.0 goes to Partitions and does full scan there. Optimizer in
> 8.1 does full scanning of Index table that takes much longer.
> Client uses Crystal Report that does not permit to enter hints to Select
> query.
> Please advise work around.
> Thank you.
> Joseph
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joseph on Mediaone
> INET: josepha_at_mediaone.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Nov 03 2000 - 17:05:01 CST