How affect to db server if analyzing table and index every day ?
Hi all,
I used oracle version 9.2.0.4 on Unix
If I need to compute size of objects in database and use this information to monitor how big is one table or index might be a candidate for moving or rebuilding in order to improve performance.
The first, I must run ANALYZE such:
ANALYZE TABLE TEST.T2 COMPUTE STATISTICS;
Or:
But I want ask just about analyze table object: If every day, I analyze some tables, this work affect to perfomance of DML ? About index, every week I scheduled shrink and analyze index.EXEC DBMS_STATS.gather_table_stats('TEST', 'T2');
0