sql gather statistics to increase performance code example
Example: sql gather statistics to increase performance
exec dbms_stats.set_global_prefs('DEGREE', DBMS_STATS.AUTO_DEGREE)
exec dbms_stats.set_global_prefs('DEGREE', DBMS_STATS.AUTO_DEGREE)