You are tuning a SQL statement, as a first step you got the execution plan. So what next - Should we add hints, cache the table, create index and the list goes on. SQL Performance tuning can be complex task if you run after symptoms and not hitting the root cause, thus making it a guessing game. The session demonstrates how the Query optimizer analyzes and works. The session talks about
1. Where to start and what to look for - Real time use case walk through
2. Hints, Index and In-memory myths
3. Query rewrite methods for better performance
4. Understand how to utilize new Oracle features with know how use cases.
