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

  • Anjaneyulu signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 11 hours ago
  • snans signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 1 day ago
  • eben kota signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 1 day ago
  • Nectoux signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 2 days ago
  • Abdul signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 2 days ago
 

Who's Online?

0 users and 232 guests online

Quick Poll

Are you excited about the advent of VirtaThon?