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
Received on Fri Nov 03 2000 - 14:03:14 CST
