OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » apps 11.0.3 and rule based optimizer

Home » Applications » Oracle Fusion Apps & E-Business Suite » apps 11.0.3 and rule based optimizer

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

apps 11.0.3 and rule based optimizer [message #96571]

Wed, 22 December 2004 00:07

Alan
Messages: 68
Registered: October 1999

Member

hello All,
the above version of apps runs on the RULE based optimizer. Do the table and indexes therefore need to be analyzed. Any information would be appreciated.

Alan

Report message to a moderator

Re: apps 11.0.3 and rule based optimizer [message #96572 is a reply to message #96571]

Wed, 22 December 2004 01:42

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

As I understand one needs to collect statistics even if the optimizer_mode is RULE (both 10.7 & 11.0) as some of the code may have cost based hints in it.

Best regards.

Frank

Report message to a moderator

Previous Topic:	What development tools are used?
Next Topic:	ERP Level 2 Support Analyst (Permanent position)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 01 19:55:22 CDT 2025