Using Hints to Drive the Oracle CBO / Cost Based Optimizer

REGISTER FOR THIS WEBINAR

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.

Prerequisite Knowledge

SQL SELECT statement; understanding simple execution plans; familiarity with the Oracle Database demo schemas. Click for a great primer on Reading Oracle Execution Plans.

Presenters 

John Watson, Oracle Certified Master DBA, SkillBuilders Director of All Things Oracle Database

Dave Anderson, SkillBuilders’ Founder, Oracle DBA

Recording

Barring any technical glitches, all webinars are recorded and posted as tutorials. See all tutorials HERE

Registration 

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.