Write For Us

Four Steps to Oracle SQL Tuning - A Methodolgy

E-Commerce Solutions SEO Solutions Marketing Solutions
253 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

admin
Published
Learn a predictable and repeatable methodology for tuning Oracle SQL statements. Just four steps that you should always follow when tuning an SQL statement. (Note this video does not contain examples of how to apply the four steps, just what the steps are.)

Oracle Certified Master John Watson presents.

John concludes with a brief overview of how SkillBuilders SQL tuning course provides the information you need to apply the four steps.

Learn more about SkillBuilders SQL Tuning course http://skillbuilders.com/oracle-sql-tuning-training

1. What is Oracle doing? (explain plan, trace)
2. Why is Oracle doing it that way? (analyze the execution plan)
3. Is there a better way? Test!
4. If there's a better way, push the CBO towards the better way.
Category
Success
Sign in or sign up to post comments.
Be the first to comment