dbms_stats.set_schema_prefs
Hello friends
Due to problems with the histograms I ran the following:
exec dbms_stats.set_schema_prefs ('USER','METHOD_OPT','FOR ALL COLUMNS SIZE 1');
But I would like to undo this, how can I do it?
Saludos
1
Hello friends
Due to problems with the histograms I ran the following:
exec dbms_stats.set_schema_prefs ('USER','METHOD_OPT','FOR ALL COLUMNS SIZE 1');
But I would like to undo this, how can I do it?
Saludos