Sometimes a SQL performs better when given an Optimizer hint. However in some scenarios it is not possible to modify the SQL (maybe it is
Category: SQL Query performance
![Photo by Einar Storsul on Unsplash](http://www.aamirharoon.com/wp-content/uploads/2020/10/photo-1546185363-b188cc935569-e1608058035797.jpeg)
….yes, that is correct. 🙂 You can apply an execution plan even if it has been aged out from your local Automatic Workload Repository (AWR).
![](http://www.aamirharoon.com/wp-content/uploads/2016/11/guia-google-analytics.png)
At work I came across a query that was using correlated sub select and I thought it is worth sharing. I have seen many queries