Task #18611
closedOracle SQL Optimization
Description
SQL_ID 3zsqm4u5cmxaz¶
SELECT COUNT(*) FROM CUSRES_DECLARATION WHERE CONTAINER_REFERENCE = :B7 AND BL_NUMBER = :B6 AND CUSRES_TYPE = :B5 AND ATP = :B4 AND MESSAGE_TYPE = 'IMPORT' AND (BOE = CASE WHEN :B3 IS NOT NULL THEN :B3 ELSE BOE END) AND (BOE_VERSION = CASE WHEN :B2 IS NOT NULL THEN :B2 ELSE BOE_VERSION END) AND (SCAN_EXAM_FLAG = CASE WHEN :B1 IS NOT NULL THEN :B1 ELSE SCAN_EXAM_FLAG END)
Plan hash value: 1953298915
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |¶
| 0 | SELECT STATEMENT | | | | 6 (100)| | | 1 | SORT AGGREGATE | | 1 | 66 | | | |* 2 | TABLE ACCESS BY INDEX ROWID BATCHED| CUSRES_DECLARATION | 1 | 66 | 6 (0)| 00:00:01 | |* 3 | INDEX RANGE SCAN | IDX_CUSRES_DECL_CONT_REF | 3 | | 3 (0)| 00:00:01 |¶
Predicate Information (identified by operation id):¶
2 - filter(("BL_NUMBER"=:B6 AND "ATP"=:B4 AND "CUSRES_TYPE"=:B5 AND "BOE"=CASE WHEN (:B3 IS NOT NULL) THEN :B3 ELSE "BOE" END AND "BOE_VERSION"=CASE WHEN (:B2 IS NOT NULL) THEN :B2 ELSE "BOE_VERSION" END AND "SCAN_EXAM_FLAG"=CASE WHEN (:B1 IS NOT NULL) THEN :B1 ELSE "SCAN_EXAM_FLAG" END
AND "MESSAGE_TYPE"='IMPORT')) 3 - access("CONTAINER_REFERENCE"=:B7)
GitLab Sync Log
[{"id": "28389", "author": "Nirmal Shibchurn", "hours": 1.0, "created": "2025-08-18T05:30:41.129Z", "log_date": "2025-08-18", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-08-18T05:30:41.129Z: 1h-(1.0)h spend at: 2025-08-18", "status": "active", "deleted_by": "", "redmine_entry_id": 10083}]