The online + compute is "fixed" in 9 hth connor
--- [EMAIL PROTECTED] wrote: > I think you are correct Charlie, > In 8i statistics can be collected when you are > creating or altering an > index. You must use compute statistics (estimate is > not an option). > You can rebuild an index and compute statistics, > however you cannot do it > using the online keyword > > John > > -----Original Message----- > [mailto:[EMAIL PROTECTED]] > Sent: 16 October 2002 18:44 > To: Multiple recipients of list ORACLE-L > > > > At least on my DB's doing ALTER INDEX <index_name> > REBUILD does in fact > populate the statistics. > I discovered this by accident on one RBO DB which > started giving poor > performnce after doing some > REBUILDs (OPTOMIZER_MODE=CHOOSE). > > > > > > ora ak > > <ora_magic@yahoo. To: > Multiple recipients > of list ORACLE-L <[EMAIL PROTECTED]> > com> cc: > > Sent by: > Subject: Re: Difference - > Rebuild and Analyze index > > [EMAIL PROTECTED] > > > > > > 10/16/2002 08:49 > > AM > > Please respond to > > ORACLE-L > > > > > > > > > > Yes Marul , I think there is a big differenece in > them . When you are > rebulding the index means you are re-organzing the > entries in the index , > may be removing the entries for the rows deleted in > past and so forth so > on. But this doesn't generate any statistics about > index. > > > When you analyze index, you generate information ( > statistics) about the > data in index , like leaf blocks or depth of index > etc. > > > None of these should require orther , but they have > some effect . > > > Like if you rebuild index , after that you dont have > latest statistics and > queries may not perform upto mark . > > > -oramagic > > > Marul Mehta <[EMAIL PROTECTED]> wrote: > Hi, > > > > Can anybody please tell me the difference between - > > SQL > execute > DBMS_UTILITY.ANALYZE_SCHEMA('BLAH','COMPUTE',NULL,30,'FOR > ALL INDEXES'); > and > SQL > select 'ALTER INDEX ' || INDEX_NAME || ' > REBUILD ONLINE;' from > USER_INDEXES > If I execute any one the above do i need to execute > the other also? > > After how many days/hour it should be executed. > > > TIA, > Marul. > > > > Do you Yahoo!? > Faith Hill - Exclusive Performances, Videos, & more > faith.yahoo.com > > > > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > 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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > 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). ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
