we are using dbms_stats, "gather auto", "for all indexed columns" and estimate 15%
Now if my other DBA would just show up for work, I can ask him about this. Sometimes being the "early bird" has disadvantages. I do know that when the analyze is not done, we have performance problems. Or at least the end-users complain about performance. Of course part of the problem is that they can do any sort of requests through the system, which turn into ad-hoc queries which end up returning enormous amounts of data. so they moan the database is too slow. --- Tanel Poder <[EMAIL PROTECTED]> wrote: > > however Jonathan's point may well be the reason. This is an > > ever-growing database, frequent insert and updates, and sequences > are > > used throughout. > > Analyze is "estimate" at least. > > Or update HIVAL and DISTCNT and ROWCNT statistics using dbms_stats > regularly... > > Tanel. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tanel Poder > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).