Loading the Oracle Dev Gym leaderboards was taking a looooooong time. 

The culprit? 

Slow SQL statements.

To make the leaderboards load fast we needed to tune them. But first we needed to identify what was slow.

Watch this session to see how we used Oracle APEX debugging tools to profile the pages. Then reviewed the execution plans to figure out how to make the slow queries fast.

To learn more about Oracle SQL tuning, join the free class Databases for Developers: Performance