Oracle-L: Re: Difference - Rebuild and Analyze index

From: Darshan Singh <darshan.singh_at_skandiabank.ch>
Date: Wed, 16 Oct 2002 04:23:34 -0800
Message-ID: <F001.004EA407.20021016042334@fatcity.com>

Hi,
There is one major difference is that rebuilding index removes the internal fragmentation and analyze just calculat the statistics. The frequency of analyzing schema depends on the schema modification frequency. One can do this on weekly basis, mostly done on week end with cron jobs.

Regards
Darshan Singh

Original Message ----- From: Marul Mehta To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 16, 2002 1:43 PM Subject: Difference - Rebuild and Analyze index

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.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Darshan Singh
INET: darshan.singh_at_skandiabank.ch

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 Wed Oct 16 2002 - 07:23:34 CDT