My Secret for tuning complex Oracle SQL queries

In College, the professors require "syntactically tight" SQL, showing all of the features such as inline views and nested subqueries.  But the academic solution is often hard to read, and the nested subqueries perform very poorly.  Traditionally, un-nesting subqueries can have a tremendous performance impact, and Oracle provides two tools for this, CTAS with Global Temporary tables and the exciting SQL99 WITH clause.

Read below how you can simplify and improve the performance of complex Oracle queries:

http://www.dba-oracle.com/t_sql_rewrite_temporary_tables.htm

*****************************************

Need an Oracle Mentor?

Oracle cannot be learned in a vacuum, and they only way to become an Oracle guru is with the help of an experienced Oracle professional.

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call me at 800-766-1884 for details, and check-out our on-site Oracle training catalog:

http://www.dba-oracle.com/bc-catalog.pdf