Performance Issue Relative To Temporary Table

Do stat on global temp will bring performance issue, so the following action is to delete them.

Deleted the statistics on the following below global temp tables: 

  DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname =>'*_TEMP'); 

  DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname =>'*_TEMP'); 

  DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname =>'**_TEMP'); 

  DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname =>'**_TEMP'); 

  DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname =>'**_TEMP'); 

Profile CST_GATHER_STATS=N (**: Cost update- Gather Statistics) - This will prevent stats

gathering on the GTT tables that might cause the performance issue.