best practice to update statistics Data warehouse
RDBMS 12c Rac
Hello
I would like to know what is the best way to gather statistics is a data Warehouse database some tables are static others no, currently we gather stats using the following command, however takes a very long time:
set timing on
set serveroutput on
begin
DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>NULL,estimate_percent=>95, cascade=>TRUE);
end;
/