Index - Performance query
in Database
Hi Team,
We are using Oracle Database 19.28 version. We need your support in fixing the below SQL query appeared in SQL ordered by Elapsed Time in AWR report. CPU consumption seems more than 90%.
1)Will index creation help in this case? If yes, please kindly lets us know which type of index to be created.
2)Which column should we place first, in case of concatenated index.
SQL> select * from table(dbms_xplan.display_cursor('0v56uxs37xf8k'));6
PLAN_TABLE_OUTPUT
SQL_ID 0v56uxs37xf8k, child number 0
SELECT MEANING PENALTYDATE FROM XXTTD.FND_LOOKUP_VALUES WHERE
LOOKUP_TYPE = 'XXTTDAR_DCB_TPTPNTY_DATE_VS' AND ENABLED_FLAG = 'Y'
Tagged:
0