L PROTECTED]>cc:
Sent by: Subject: RE: In an Analyze Necessary?
[E
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
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
Sent by: Subject: Re: In an Analyze Necessary?
[EMAIL PROTECTED]
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. Ther
