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


Comments

Popular posts from this blog

Project euler 169 found clue

Floyd-Warshall's algorithm