Thursday, 8 September 2022

Gather Schema Stats in Oracle Database 19c

Begin
dbms_stats.gather_schema_stats(ownname => 'GL',
options =>'GATHER AUTO',
estimate_percent => dbms_stats.auto_sample_size,
method_opt => 'for all columns size repeat',
degree => 2);
END;

No comments:

Post a Comment