Quickly fix bad statements with SQL Patch

In Oracle Database you can use the SQL Patch feature to easily change a statement that does not perform good enough. Without the application or client knowing you can inject optimizer hints, that can ensure that the optimizer can come up with a better plan.

Presenters are Roy Swonger, Mike Dietrich, and Daniel Overby Hansen

[sanjayvideo]

Thanks, It is very simple example. Can you give more detail on sql which are using bind variables and also what about sql statements which are very complex like have subquery at multiple levels ?