Performance of sql query - Oracle
Hi Team,
We are on 19.28 Oracle Database version.
Please kindly suggest, if we can avoid the full table scan, column order.
SELECT MAX(VERSION_HISTORY) FROM XXTTD.XXTTD_AP_MB_LINITEM_HIST_TAB
WHERE MBOOK_BILL_HEADER_ID = :B5 AND MBOOK_BILL_HEADER_ID = :B4 AND :B4
= :B3 AND MBOOK_BILL_LINE_ID = :B2 AND :B2 = :B1
Plan hash value: 4209819504
----------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 55507 (100)| |
| 1 | SORT AGGREGATE | | 1 | 14 | | |
|* 2 | FILTER | | | | | |
|* 3 | TABLE ACCESS FULL| XXTTD_AP_MB_LINITEM_HIST_TAB | 1 | 14 | 55507 (1)| 00:00:03 |
----------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
2 - filter((:B2=:B1 AND :B4=:B3 AND :B4=TO_NUMBER(:B5)))