Home » Applications » Oracle Fusion Apps & E-Business Suite » apps 11.0.3 and rule based optimizer
apps 11.0.3 and rule based optimizer [message #96571] Wed, 22 December 2004 00:07 Go to next message
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
Re: apps 11.0.3 and rule based optimizer [message #96572 is a reply to message #96571] Wed, 22 December 2004 01:42 Go to previous message
Frank Naude
Messages: 4579
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
Previous Topic: What development tools are used?
Next Topic: ERP Level 2 Support Analyst (Permanent position)
Goto Forum:
  


Current Time: Fri Mar 29 00:10:40 CDT 2024