We improved the query by 40% and the report was still slow
A real client performance problem, a personal benchmark setup and numbers that prove why it worked. TL;DR: ORDS is Oracle's tool for exposing database data as REST services. If your ORDS handler builds its JSON response using a PL/SQL loop with JSON_OBJECT_T, replacing it