Re: Difference - Rebuild and Analyze index

[Darshan Singh]

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.