Time slot:
19 July 12:30 - 13:25
Room:
Virtual Room # 200 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
- Login to post comments
Mar 27, 2011
Stalk VirtaThon @
Like VirtaThon?
LIVE Activity Stream
-
hossam signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
8 hours ago
-
ally mcintyre signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
1 day ago
-
prefect signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
2 days ago
-
jai signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
2 days ago
-
testpremium4 signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
3 days ago
Who's Online?
0 users
and 346 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.