Oracle Database Administrator
Monday, July 14, 2025
Gather Statistics
BEGIN
DBMS_STATS.GATHER_TABLE_STATS(
ownname => 'HR',
tabname => 'EMPLOYEES',
estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
method_opt => 'FOR ALL COLUMNS SIZE SKEWONLY',
cascade => TRUE
);
END;
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)