Session ID: 
1114
Presenter(s): 

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.
Track/Stream: 
Database - Oracle
Category: 
Conference Session
Group: 
360 Degree Overview
Session Length: 
60 Minutes
Status: 
Accepted
Target Audience: 

All

Stalk VirtaThon @

  • Facebook Page: 113995341985805
  • FeedBurner: brainsurface
  • Twitter: brainsurface
  • YouTube: brainsurface
  • External Link: paper.li/brainsurface/oracle-java-headlines

Like VirtaThon?

Joomla Templates and Joomla Extensions by JoomlaVision.Com

LIVE Activity Stream

  • Dhana Ram signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 18 hours ago
  • flx signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 1 day ago
  • Krishna signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 2 days ago
  • salhi signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 4 days ago
  • Mohammed signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 5 days ago
 

Who's Online?

0 users and 265 guests online

Quick Poll

Are you excited about the advent of VirtaThon?