Re: Large Tables, Bad Indexes and Fake Statistics

From: Don Seiler <don_at_seiler.us>
Date: Tue, 19 Jun 2007 12:34:04 -0500
Message-ID: <716f7a630706191034n733f5a28gc3b1427322deb7c4@mail.gmail.com>

On 6/19/07, Don Seiler <don_at_seiler.us> 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

Received on Tue Jun 19 2007 - 12:34:04 CDT

This message: [ Message body ]
Next message: David Barbour: "Re: Copying Large Amounts of Data From Prod to Dev"
Previous message: Kerber, Andrew W.: "RE: How could you tell if an applicaiton will run in Standard Edition"
In reply to: Don Seiler: "Large Tables, Bad Indexes and Fake Statistics"
Next in thread: jaromir nemec: "Re: Large Tables, Bad Indexes and Fake Statistics"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US