Time slot:
19 July 12:30 - 13:25
Room:
Virtual Room # 100 Session ID:
1068
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
- Understanding Oracle Explain Plan
- 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
- Login to post comments
Mar 09, 2011
Stalk VirtaThon @
Like VirtaThon?
LIVE Activity Stream
-
prefect signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
17 hours ago
-
jai signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
1 day ago
-
testpremium4 signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
1 day ago
-
Le Quoc Dinh signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
1 day ago
-
vimal kakadiya signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
1 day ago
-
ludovick signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
1 day ago
-
Prabhu signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
1 day ago
Who's Online?
0 users
and 190 guests
online
Quick Poll
Are you excited about the advent of VirtaThon?
Top Members
Scroll To Top
About BrainSurface | The Collaborative ConnectSpace for Oracle, Java & MySQL Professionals
BrainSurface is the most Powerful, Advanced & Extensible ConnectSpace for Oracle, Java & MySQL professionals and is built on and driven by the following themes:
Next-Generation Social Networking
State-of-the-Art IT Collaboration
BrainSurface is broadly aimed at sharing, collaborating and reusing all the edges of technology and technical/functional knowledge that, we come accross in our professional lives within the generalized realm of the Oracle, Java & MySQL communities. BrainSurface is the FIRST of its kind in bringing Social Networking and ALL known collaborative paradigms under one roof for this very purpose: Online Virtual Conferencing, Webinars & Webcasts, Social Collaboration, Document Publishing, Blogging in all its variant forms, Videos, Discussions, Forums, Job Repository, Project Management and a whole lot more. All Collaboration and Social Networking components within BrainSurface are bleeding-edge, intuitive and feature-rich. Best of all: membership at BrainSurface is 100% FREE!
Disclaimer: VirtaThon and BrainSurface are not affiliated or supported by Oracle Corporation and its affiliates/subsidiaries. Oracle, Java, MySQL and others are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.