Query performance degraded after upgrade to 19c
We're working on an upgrade project to upgrade our 11g database to 19c.
The 11g database has been upgraded to 19c on a test server & our application are running test on some of their applications.
During the test they've found that some queries are running very slowly. Below are comparison between the current 11g explain plan and 19c explain plan for the same query. Is there anyway for me to improve the query running on 19c?
Explain plan for 11g
The 11g database has been upgraded to 19c on a test server & our application are running test on some of their applications.
During the test they've found that some queries are running very slowly. Below are comparison between the current 11g explain plan and 19c explain plan for the same query. Is there anyway for me to improve the query running on 19c?
Explain plan for 11g
<div>--------------------------------------------------------------------------------------------------------------------</div><div>| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |</div><div>--------------------------------------------------------------------------------------------------------------------</div><div>| 0 | SELECT STATEMENT | | 4 | 2088 | 38 (3)| 00:00:01 |</div><div>| 1 | HASH GROUP BY |
0