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

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

  • aravindan v signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 12 days ago
  • Alonso signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 21 days ago
  • Prajeesh signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 25 days ago
  • uones signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 28 days ago
  • Soudabeh signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 29 days ago
  • prasad signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 34 days ago
 

Who's Online?

0 users and 130 guests online

Quick Poll

Are you excited about the advent of VirtaThon?