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

  • ugoquzu created a new topic ' Immediate Methods For car Described' in the forum.
    kunena.post 18 hours ago
  • ugoquzu signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 18 hours ago
  • ewifuve signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 21 hours ago
  • ogaxilik created a new topic ' Burglar Stop Leading R' in the forum.
    kunena.post 22 hours ago
  • ogaxilik signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 22 hours ago
  • amojyq created a new topic ' Shoes yummiest enjoyed rescan.' in the forum.
    kunena.post 1 day ago
  • amojyq signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 1 day ago
 

Who's Online?

0 users and 745 guests online

Quick Poll

Are you excited about the advent of VirtaThon?