dbms_stats.set_table_prefs('<owner>','<table>','PUBLISH','FALSE');
dbms_stats.gather_table_stats('<owner>','<table>',degree =>8,method_opt => 'for all columns size 1',estimate_percent => 20);
SELECT TABLE_NAME,PARTITION_NAME ,LAST_ANALYZED FROM DBA_TAB_PENDING_STATS;
ou
select dbms_stats.get_prefs('PUBLISH',<owner>,'<table>') from dual;
alter session set optimizer_use_pending_statistics=TRUE;
test ...
alter session set optimizer_use_pending_statistics=FALSE;
si c'est bon
EXEC DBMS_STATS.PUBLISH_PENDING_STATS ('<owner>','<table>');
Partager