SQL Patch – fast way to add a hint without changing the code

SQL Patches are internally used by SQL Recovery advisor to fix SQL statements that fail with critical errors at run time. SQL Recovery advisor does this job by patching / hints the SQL statement, basically telling the optimizer to avoid an access path for example. The same undocumented package can also be used to insert … Continue reading SQL Patch – fast way to add a hint without changing the code