Session ID: 

It is a common question among developers and database administers alike, why can't the optimizer optimize my SQL better? There are many reasons why optimizer chose an inefficient plan. This presentation is to probe those reasons and introduce various concepts behind these reasons. Various techniques to overcome these drawbacks will be discussed. This presentation emphasis is on simple examples to clarify understanding of common issues dealt in the real life production performance experience. Various topics such as selectivity, cardinality, histograms, indexing issues, structural deficiencies of tables and indices, Cost based optimizer environment setup etc, will be discussed in detail.

Schedule info

Session Objectives: 
Audience will understand basic concepts about optimizer and reasons as to why optimizer was not able to choose most efficient execution plan.
Database - Oracle
Conference Session
360 Degree Overview
Session Length: 
60 Minutes
Target Audience: 


Stalk VirtaThon @

  • Facebook Page: 113995341985805
  • FeedBurner: brainsurface
  • Twitter: brainsurface
  • YouTube: brainsurface
  • External Link:

Like VirtaThon?

Joomla Templates and Joomla Extensions by JoomlaVision.Com

LIVE Activity Stream


Who's Online?

0 users and 188 guests online

Quick Poll

Are you excited about the advent of VirtaThon?