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.

Reply via email to