Write For Us

How to Tune SQL when You Can't Edit the Source Code, Part 1 of 2

E-Commerce Solutions SEO Solutions Marketing Solutions
224 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

admin
Published
How do you add a hint to SQL you can't edit? How do you tune SQL if you don't have access to the source code? Sometimes, Oracle indexes, statistics, stored outlines, profiles or 12c directives will solve a tuning problem. However, as a last resort, you may want to add a hint. In this case DBMS_ADVANCED_REWRITE can be the solution. In this tutorial, Oracle Certified Master DBA John Watson of SkillBuilders demonstrates using DBMS_ADVANCED_REWRITE to change the SQL Oracle executes - without changing the source code!
Category
Success
Sign in or sign up to post comments.
Be the first to comment