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

  • Chi signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 5 hours ago
  • Farrukh Kamal signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 20 hours ago
  • Ash signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 1 day ago
  • Mark Powell signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 1 day ago
  • Luqman signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 2 days ago
  • Deepak signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 3 days ago
 

Who's Online?

0 users and 338 guests online

Quick Poll

Are you excited about the advent of VirtaThon?