how to analyze table index

analyze table document compute statistics

ex) DOCUMENT Table 만 Analyze

 

analyze index xpkdocbox compute statistics

ex) XPKDOCBOX Index 만 Analyze

select 'analyze table ' || table_name || ' estimate statistics;' from user_tables



select 'analyze index || index_name || estimate statistics;' from user_indexes