Oracle … as usual

Oracle by Laurent Leturgez

Monthly Archives: October 2016

OTN Appreciation Day: SQL Patch

Feature: SQL Patch.

Why : Because, it can help you to use some hints on a non editable query (for example, in a packaged application). In order to stabilize performance of this kind of application, it’s very useful.

Why not: Because sometimes, having many execution plans for a SQL Statement is better than one.

If you don’t understand why such a short post, or why this post .. please read this: https://oracle-base.com/blog/2016/09/28/otn-appreciation-day/
Many thanks to Tim Hall (@oraclebase) for the Idea 😉