Funny ... that Cary mentioned it ....
Some developers here think that by setting some magic instance parameters we can make all RBO tuned code run well under CBO ... (I just bought a 6 pack of Mylanta yesterday ...)
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
____________________Reply Separator____________________
Author: "Cary Millsap" <[EMAIL PROTECTED]>
Date: 11/14/2002 10:34 AM
Hamid,
I'm sorry: Unless your SQL returns fewer than about 800,000 rows to the
calling application (or an aggregation of 800,000 rows), then the
statement "we have done all the necessary tuning on all the SQL queries"
is not yet true.
If your SQL does actually return about 800,000 rows, then it is time to
begin thinking about the mismatch between business processing
requirements and the logical structure of your data.
The answer to your problem is not in your instance parameters.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1
