> and Oracle is kludgy and outmoded While adding EXPLAIN support to Django I ran into a very kludgy issue with Oracle. To EXPLAIN a query you need to: 1. Add

> and Oracle is kludgy and outmoded While adding EXPLAIN support to Django I ran into a very kludgy issue with Oracle. To EXPLAIN a query you need to: 1. Add an EXPLAIN PLAN FOR prefix, and give it a unique ID (and make sure it is unique!) 2. This plan is then written to a special table that you may or may not have access to, and may or may not be renamed. 3. Execute `DBMS_XPLAN.DISPLAY()` with the UUID you gave above (this function is not always available) 4. Find out that you cannot use any parameters with your SQL query while explaining, then give up. Madness.