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

 

Who's Online?

0 users and 444 guests online

Quick Poll

Are you excited about the advent of VirtaThon?