PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- SQL_ID 6kjzzq1v801yj, child number 0 ------------------------------------- UPDATE DWH_TOT_BILL_AMT s SET s.cn = ( SELECT COUNT (*) FROM DWH_DETAIL_BILL_AMT c WHERE s.account_code_n = c.account_code GROUP BY c.account_code) WHERE s.LAST_BILL_DATE IS NULL Plan hash value: 1002585588 -------------------------------------------------------------------------------- -------------- PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- | Id | Operation | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time | -------------------------------------------------------------------------------- -------------- | 0 | UPDATE STATEMENT | | | | 126M(100)| | | 1 | UPDATE | DWH_TOT_BILL_AMT | | | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- | | |* 2 | TABLE ACCESS FULL | DWH_TOT_BILL_AMT | 75711 | 1700K| 85 (2)| 00:00:01 | | 3 | SORT GROUP BY NOSORT| | 1 | 6 | 1677 (1)| 00:00:01 | |* 4 | TABLE ACCESS FULL | DWH_DETAIL_BILL_AMT | 5 | 30 | 1677 (1)| 00:00:01 | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter("S"."LAST_BILL_DATE" IS NULL) 4 - filter("C"."ACCOUNT_CODE"=TO_NUMBER(:B1)) Note PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- ----- - Warning: basic plan statistics not available. These are only collected when : * hint 'gather_plan_statistics' is used for the statement or * parameter 'statistics_level' is set to 'ALL', at session or system leve l