Re: Large Tables, Bad Indexes and Fake Statistics
- From: "Don Seiler" <don@xxxxxxxxx>
- To: oracle_l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Jun 2007 12:34:04 -0500
On 6/19/07, Don Seiler <don@xxxxxxxxx> wrote:
did notice that the dba_tab_statistics table showed a sample_size for
my user-set stats, when I don't believe there was one before.
Nevermind I just must not have noticed it. I did a delete and set
again and it did set the sample size. Nix one more wild theory of
mine!
--
Don Seiler
oracle blog: http://ora.seiler.us
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l
- References:
- Large Tables, Bad Indexes and Fake Statistics
- From: Don Seiler
Other related posts:
- » Large Tables, Bad Indexes and Fake Statistics
- » Re: Large Tables, Bad Indexes and Fake Statistics
- » Re: Large Tables, Bad Indexes and Fake Statistics
- » Re: Large Tables, Bad Indexes and Fake Statistics
- » Re: Large Tables, Bad Indexes and Fake Statistics
- » Re: Large Tables, Bad Indexes and Fake Statistics
did notice that the dba_tab_statistics table showed a sample_size for my user-set stats, when I don't believe there was one before.
- Large Tables, Bad Indexes and Fake Statistics
- From: Don Seiler