STATISTICHE

BEGIN 
dbms_stats.gather_schema_stats(
ownname=>'SCHEMA',
METHOD_OPT=>'FOR ALL INDEXED COLUMNS SIZE SKEWONLY',
CASCADE=>TRUE,
ESTIMATE_PERCENT=>10);
END;
/