Hi Experts,
I have been asked to tune the query and after creating the index the explain plan shows there is significant reduction of cost, however even after creating the index the same sql is taking around same time if I execute on Sql developer.
Please help me understand how can I convince performance team if there is real improvement.
Here is the query and the tables Arpp_Decisions contain around 27M records and the query returns 20K records.
Explain plan prior to the index:
Explain plan after creating the index:
Version : Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production