Techniques for optimizing subquery performance in SQL tuning
How to optimize recursive SQL queries
Tuning SQL queries for parallel execution
Using bind variables to improve SQL query performance
Best practices for parameterizing SQL queries for better performance