Re: Help: Is cost of explain plan reliable?
From: m. fowler <mfowler_at_dot.co.pima.az.us>
Date: 22 Apr 2002 07:24:51 -0700
Message-ID: <e9c5a67.0204220624.3ded9962_at_posting.google.com>
Date: 22 Apr 2002 07:24:51 -0700
Message-ID: <e9c5a67.0204220624.3ded9962_at_posting.google.com>
[Quoted] It's recommended that DBMS_STATS be used in place of ANALYZE, depending on your version - let the db decide what needs to be analyzed, how much data to look at, how many buckets and so on.
> Run the ANALYSE command to bring the statistics up to date. Run the
> analyse frequently enough to keep them up to date. I notice that the
> people I work with always re-analyse everything once per day. Don't know
> if its recommended anywhere, but that's what they do.
Received on Mon Apr 22 2002 - 16:24:51 CEST