After Upgrade, SQL Performance Is Slower Or Different Physical SQL Is Generated For Same Logical SQL
(Doc ID 2043834.1)
Last updated on JANUARY 25, 2024
Applies to:
Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 to 12.2.1.4.0 [Release 11g to 12g]Oracle Analytics Cloud - Version N/A and later
Information in this document applies to any platform.
Symptoms
You may notice after an upgrade from one on-premises version to another on-premises version you may notice that:
- A query may perform slower to the same Oracle database.
- You may observe that there is different physical SQL generated (i.e. - with more joins, table scans,etc.) in each environment but the same logical SQL is generated.
- The database features (DbFeatures.defaults are identical)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |