- This event has passed.
Using Hints to Drive the Oracle CBO / Cost Based Optimizer
August 11, 2021 @ 1:00 pm - 2:00 pm EDT
Using Hints to Drive the Oracle Cost Based Optimizer (CBO)
How, Why and When to Use Hints to Alter Oracle Optimizer Decisions
When should hints be used (one possible answer is “never”) and how do you use them? What can they do? When you do use them, why are they sometimes ignored? Why do Oracle DBAs and Developers often disagree when it comes to using hints? Hints can be a powerful facility for making your code run better, but are they really a good thing? This webinar will go through some usage cases for hints, the syntax and effects (and side effects…) of the most commonly used hints, and some of the many problems encountered when using them.
SQL SELECT statement; understanding simple execution plans; familiarity with the Oracle Database demo schemas. Click for a great primer on Reading Oracle Execution Plans.
John Watson, Oracle Certified Master DBA, SkillBuilders Director of All Things Oracle Database
Dave Anderson, SkillBuilders’ Founder, Oracle DBA
Barring any technical glitches, all webinars are recorded and posted as tutorials. See all tutorials HERE
By registering for the webinar, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.
All dates are in Eastern Time (ET).