Session ID: 
1069
Presenter(s): 

This presentation is a must-see for anyone doing SQL tuning. Dan has a thorough understanding of how the Cost-Based Optimizer works and shares that knowledge in this presentation.

Dan covers:
- Useful Explain Plan tools and scripts
- Parallel SQL Explain Plans
- Dan Covers:
- How the CBO makes its decisions
- Query Transformations
- How tables are processed/joined
- How Indexes are processed
- Explain Plan Line Items

Schedule info

Session Objectives: 
This is a live-demo presentation. Dan shows how to work with Explain Plans then goes into considerable detail about exactly how Oracle arrives at an Explain Plan. Dan is an experienced trainer with considerable knowledge on this topic. The attendee will gain valuable insights as to how Oracle processes SQL and many tips on how to improve SQL performance.
Track/Stream: 
Database - Oracle
Category: 
Conference Session
Group: 
Expert Insight, Tips & Tricks
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

  • chetan signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 48 days ago
  • Samir Chitre signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 49 days ago
  • mohammed signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 56 days ago
  • rajesh signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 56 days ago
  • Anju Garg signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 59 days ago
  • Jelili Agoro signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 62 days ago
  • mohammad signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 65 days ago
 

Who's Online?

0 users and 207 guests online

Quick Poll

Are you excited about the advent of VirtaThon?