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


Popular posts from this blog

codefights smooth sailing ( CommonCharacterCount)

How to remove 8443 port in URL in tomcat