parameters in dbms_stats

From: "Ojha, Ajeet (GE Healthcare, consultant)" <Ajeet.Ojha@xxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 1 Apr 2010 13:17:17 +0530

Hello All

 

What is the menaing of two parameters used in
dbms_stats.gather_table_stats

 

1)       NO_INVALIDATE

2)       FORCE

 

When and  why we should be using them. What is advantage and
disadvantages of using them .

 

 

Thanks much.

Follow-Ups:
- Re: parameters in dbms_stats
  - From: Jost,
- RE: parameters in dbms_stats
  - From: Ric Van Dyke

Other related posts:

» parameters in dbms_stats - Ojha, Ajeet (GE Healthcare, consultant)
» Re: parameters in dbms_stats- Jost,
» RE: parameters in dbms_stats- Ric Van Dyke