Time slot:
19 July 17:30 - 18:25
Room:
Virtual Room # 100 Session ID:
1084
Presenter(s):
Each release of Oracle introduces new features to the SQL and PL/SQL languages some of which are designed to optimize performance, others of which are intended to improve programmer productivity. In many cases, using these new idioms will have definite performance implications. In this talk we'll look at new language features and how best to exploit them to achieve optimal performance. Topics covered will include:
* Using the PARTITION BY analytic function as an alternative to GROUP BY.
* New clauses in CONNECT BY hierarchical queries
* PIVOT and UNPIVOT performance
* DML enhancements such MERGE and multi-table INSERTS
* PLSQL Function caching, in-lining, native compilation and other 11g PLSQL optimizations
Schedule info
Session Objectives:
The presentation will help attendees become more familiar with new features of Oracle 11g that can improve performance and will see how best to integrate this new features in their SQL and PL/SQL code.
Track/Stream:
Development - Oracle Category:
Conference Session
Group:
Expert Insight, Tips & Tricks
Session Length:
60 Minutes
Status:
Accepted
Target Audience:
All
- Login to post comments
Mar 15, 2011
Stalk VirtaThon @
Like VirtaThon?
LIVE Activity Stream
-
Mohit Jain signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
9 hours ago
-
Tamer signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
10 hours ago
-
Kodi signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
14 hours ago
-
hossam signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
1 day ago
-
ally mcintyre signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
2 days ago
-
prefect signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
3 days ago
Who's Online?
0 users
and 172 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.