Re: After table analyzed query runs 8 hours longer

Daniel Roy wrote:

> From what I see, your slow-running query accesses multiple tables, but
> you say that you calculated stats for ONE table. Be consistent and
> analyze the stats for ALL the tables involved. Please post at least
> the query.
>
> Daniel

And, in addition, do not use DBMS_UTLITY procedures ... you should be using DBMS_STATS.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)