- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Looking at this procedure, it seems like is estimated/derived from the database based on usage statistics?
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | -- stored procedure called to update table statistics -- can be changed accoring to your preferences as a DBA CREATE OR REPLACE PROCEDURE up_UpdateTableStats(sSchema varchar2, sTable varchar2, iPercent INTEGER) IS BEGIN IF UPPER(sTable) IN ('TMPBROADCAST', 'TMPBROADCASTPAPER') THEN DBMS_STATS.SET_TABLE_STATS(USER, 'TMPBROADCAST', numrows=> 2000000, numblks=>40000); ELSE DBMS_STATS.GATHER_TABLE_STATS(ownname => sSchema, tabname => sTable, estimate_percent => iPercent, cascade => true); END IF; END; / |