Cloud Architecture. Open-Source Databases. Data-Driven Solutions.
Cloud Architecture. Open-Source Databases. Data-Driven Solutions.
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 vendor code). Or a SQL performs better in one database but it is using different…
….yes, that is correct. 🙂 You can apply an execution plan even if it has been aged out from your local Automatic Workload Repository (AWR). But first you’ll need a graveyard 🙂 , in other words AWR Warehouse Repository. AWR…
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 where correlated sub select is used which can easily be written using analytics. In this…