Monday, May 6, 2013

Using Optimizer Hints for Oracle Performance Tuning


My next Embarcadero sponsored webinar will be on May 14 and is entitled Using Optimizer Hints for Oracle Performance Tuning.

Register now!


Hints are excellent database performance tuning tools that direct the Oracle optimizer to utilize specific operations in SQL execution plans. We often use hints because the Oracle optimizer doesn’t always come up with the execution plan we want on its own. When used correctly, hints can help stabilize an execution plan to use the same operations over and over allowing the SQL to perform the way we desire.

In this webinar, I'll take a look at using hints specifically for testing. Hints are great, and often overlooked, testing tools.

Register for Optimizer Hints for Oracle Performance Tuning webinar to learn:
  • The basics of using optimizer hints to choose desired plan operations 
  • How to setup and compare tests using different optimizer hints for changes in response time and resource consumption 
  • How to create and maintain an information repository of testing results to be used for problem analysis in the future 
  • Tools for applying and testing a broad range of hints 
Thanks again to Embarcadero (@DBPowerStudio) for their sponsorship of these webinars.

I hope to see you there!

No comments: