B - Production Support » BI FAST Support

There is 2 query to DB that might be the cause of slowness, so we suggest to check whether this query already had index on the DB, if not yet index then we suggest to add it.

--This one to get data of historical reply on the dispute detail
SELECT * FROM CI_PORTAL.RPP_DISPUTE_HISTORY WHERE
REF_NUMBER = [VALUE] and
CHG_COUNT <> 0;

--This one to get detail data from some field on the dispute detail
SELECT * FROM CI_PORTAL.RPP_TRNX_DATA_LOG WHERE
BUSINESS_MSG_ID = [VALUE];

______________________________________________________________________
On the patch probably only can enhance for RPP_DISPUTE_HISTORY query because the query before are like this:
SELECT * FROM CI_PORTAL.RPP_DISPUTE_HISTORY WHERE
REF_NUMBER = [VALUE] and
CHG_COUNT <> 0 ORDER BY LAST_MODIFIED_DATE ASC;
Then i tried to remove the 'ORDER BY' takes only half time if compare with 'ORDER BY'

The patch above is not posible about remove the ORDER BY because the front end need it.

so now we only suggest to add index for those 2 query

already solved this items together with the "Table Partition" fix activity from case redmine ID 13312 which impact RPP_TRANS_LOG_DATA. Deployed on 15/04/2023.