SLIDE 1
APEX Reporting Performance
1
APEX Reporting Performance Carsten Czarski, Oracle APEX Team 1 - - PowerPoint PPT Presentation
APEX Reporting Performance Carsten Czarski, Oracle APEX Team 1 - - PowerPoint PPT Presentation
APEX Reporting Performance Carsten Czarski, Oracle APEX Team 1 Turn on Debug Mode Review the actual SQL Query Switch to Debug Level 9 Review the *full* SQL Query And review the execution plan Some settings come at a cost
SLIDE 2
SLIDE 3
Review the actual SQL Query
SLIDE 4
Switch to Debug Level 9
SLIDE 5
Review the *full* SQL Query
SLIDE 6
And review the execution plan
SLIDE 7
Some settings come at a cost
SLIDE 8
"Optimizer Hint" is added to the most outer query.
SLIDE 9
"Optimizer Hint" is added to the most outer query.
SLIDE 10