We can Transfer Statistics between servers allowing consistent execution plans between servers with varying amounts of data. This is possible using the DBMS_STATS package Here are the steps to do for a table Step 1. Create the stat table EXEC DBMS_STATS.CREATE_STAT_TABLE('SCOTT,'STATTAB', 'TOOLS'); Step 2 Export table statistics to statistics table. EXEC DBMS_STATS.EXPORT_TABLE_STATS(OWNNAME=>'SCOTT',TABNAME=>'EMP', STATTAB=>'STATTAB',STATID=>'EXP_1',STATOWN=>'SCOTT); Step 3 […]

The post How to transfer statistics between databases appeared first on Techgoeasy.