Two or more aggregate functions in Oracle cause performance problems

There seems to be a bug with Oracle database that causes execution of two or more aggregate functions in an SQL statement to be time consuming.
Example of two aggregate functions in same query: SELECT MIN(XYZ) MAX (XYZ) FROM TABLE_XYZ;

SAP XI has one such statement in the report SXMS_PF_REORG (reorganization of adapter data).
As a work around, SAP has split the two aggregate functions in one statement to run as two separate statements. Implement SAP note 1540734 to implement SAP's workaround if you are facing performance issues with regard to this report.

Comments

Popular posts from this blog

OS/DB Migration - CMD. STR, TOC, EXT, R3load, DDLDBS.TPL and more

Fixing Inconsistent Table - Table activation fails due to inconsistency between DD and DB

301 Redirect Using SAP Web Dispatcher