Hi,

Sometimes current statistics would not be available in the data
dictionary ,isn't it?

So that job is done by this method.

-----Original Message-----
From: Vishal Agarwal [mailto:vishal.[Email address protected]
Sent: Thursday, September 29, 2005 10:19 AM
To: Sachidananda_T
Subject: Re: dbms_stats

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


thanks sachi
but when we do not gather stats for large table
then what Oracle does.I think even then it use
cost based optimizer but with defaults values.
if yes then what gather stats is a better option.

thanks and regards
Vishal





DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.


Oracle LazyDBA home page