To use the "SQL Rewrite" option, the options are:
SQL Rewrite: For when it's possible to change an application's source code, and also to compile it. SQL Optimizer can find better SQL and offer the possibility to replace it in the source code.
Plan Control: When an application is bought from a software vendor and it's only a binary executable file. If a SQL inside this application has a performance problem and it's source code can not be changed, SQL Optimizer can find better plan for this SQL and fix this plan in database. Next time the application issues this SQL, the database will use the better plan to run it. Oracle 11g or an above version is needed to use this function.
"Index" and "Rewrite and Index" buttons are only in SQL Rewrite, and "Generate Plans" button only in Plan Control type.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center