ANALYZE TABLE [OWNER].[TABELA] COMPUTE STATISTICS; select 'Analyze Table '||table_name||' compute statistics;' from user_tables; select 'Analyze Index '||index_name||' compute statistics;' from user_indexes;