结构化查询语言SQL Tuning.pptVIP

Select count(*) from PS_PAY_CALENDAR A; 2280 Select count(*) from WB_JOB B; 40000 Select count(*) from WB_RETROPAY_EARNS C; 164733 Select count(*) from PS_RETROPAY_RQST D; 13679 Select count(*) from PS_RETROPAYPGM_TBL E; 15 * * * * * * * /2007/04/26/heisenberg/ You may recall that from through to , enabling sql_trace gave you some row source execution statistics in the STAT# lines of trace files. This feature disappeared in because of the overheads, re-appearing in 10g when the parameter to set a sampling frequency was introduced. Metalink 3009359.8 higher