The online + compute is "fixed" in 9
hth
connor
- John.Hallas_at_vodafone.co.uk 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:Charlie_Mengler_at_HomeDepot.com]
> 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_at_yahoo. To:
> Multiple recipients
> of list ORACLE-L <ORACLE-L_at_fatcity.com>
> com> cc:
>
> Sent by:
> Subject: Re: Difference -
> Rebuild and Analyze index
>
> root_at_fatcity.com
>
>
>
>
>
> 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 <marul_at_zycus.com> 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: Charlie_Mengler_at_HomeDepot.com
>
> 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: ListGuru_at_fatcity.com (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: John.Hallas_at_vodafone.co.uk
>
> 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: ListGuru_at_fatcity.com (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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Thu Oct 17 2002 - 04:24:10 CDT