ORACLE-L
[EMAIL PROTECTED]
[EMAIL PROTECTED]cc:
Sent by: Subject: RE: In an Analyze Necessary
Hello Rajesh,
Since you use rule-based optimisation there is no need for analyzing.
Other benefits are:
-you can view several statistics like number of rows in table etc.
-with analyze command you can determine chained rows.
Friday, May 03, 2002, 10:48:34 PM, you wrote:
RRjc Hello Folks,
RRjc
Don't fix, if it's not broken:-)
Do something else with your spare time instead :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 03, 2002 11:48 AM
Hello Folks,
A datawarehouse. There are
:
Sent by: Subject: Re: In an Analyze Necessary?
[EMAIL PROTECTED
Rajesh,
You seem to be one of those lucky DBAs who don't have performance issues :)
Just keep in mind that when statistics are NOT present and the CBO is forced
by one of the many reasons, some defaults will be assumed. These defaults
are absolutely invalid and incorrect. So, even if you analyze