Support #13490
[SCP ID :##6659##] : Question About Query
| Status: | Closed - End of life cycle | Start date: | May 05, 2023 | |
|---|---|---|---|---|
| Priority: | Immediate | Due date: | ||
| Assignee: |  Bramantyo Pujo Wiyono | % Done: | 100% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:-
Please inform the function of this query, because its to long running in DB.
select count(*) as y0_ from RPP_TRNX_LOG_DATA this_ where (this_.TRNX_STATUS=:1 or this_.TRNX_STATUS=:2 ) and this_.COMPLETED_DATE>=:3 and this_.COMPLETED_DATE<:4 and this_.SERVICE=:5 and this_.OFI_CODE=:6 and this_.RFI_CODE=:7
DBA Team from BI just try to kill this query, but its created again with same query.
History
#1
Updated by Bramantyo Pujo Wiyono over 1 year ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- % Done changed from 0 to 30
If this query coming from APP server seems it from Transaction History.
But if it coming from REP server likely those query are from generate report CT Recapitulation Mobthly
#2
Updated by Rayvandy Gabbytian about 1 year ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- % Done changed from 30 to 100
Bram, Sep 5, 2023:
This case should be already solve by, apply table partition and enhance report using summary table