Steve,
We jumped directly from 7.3.2.3 to 8.05, both running cost based
optimization, and saw no problems of this sort. However, that is not
to say that such a problem might not exist in 7.3.4.
I would suggest trying to run the sql that generates the tables/column
list directly in a sql editor (sql programmer, DBartisan, etc), and
check out the explain plan in prod v. dev. The sql you need to run
would be found in the \\businessobjects\oracle\stora7en.txt file.
What you do based on the results of that test is up to you, but at
least you'll be able to quantify the difference.
Jason Beard
-------------------------------------------------------------------
I’m using BO4.1 with an Oracle 7.3.4 backend on Unix.
Following a recent Oracle upgrade from 7.1 whenever I try to insert a new
table into a universe, it takes over an hour to respond with a table list
in the browser
window. When I do this in development in runs fine, but in production it
take forever
and slows down the server.
Production runs with Cost based optimization, development runs with rule
based.
I’m using BO4.1 with an Oracle 7.3.4 backend on Unix.
Following a recent Oracle upgrade from 7.1 whenever I try to insert a new
table into a universe, it takes over an hour to respond with a table list
in the browser
window. When I do this in development in runs fine, but in production it
take forever
and slows down the server.
Production runs with Cost based optimization, development runs with rule
based.
Anyone experienced this?
Is it possible to manage the session optimizer mode from the client?
If you use external strategies, RE-ORDER the tyble in the FROM clause of the
strategy and add the RULE optimizer hint after the select clause, so that it looks
like (here as an example):