Secret internals of temporary tables

While tools like Oracle analytics are great for solving complex problems using only SQL, the cryptic syntax and funky performance are less than idea for production shops where maintainability and fast performance are primary goals.

Oracle has the Global Temporary table (GTT) and the SQL-99 WITH clause to allow us to decompose a large and complex query into its components.  This divide and conquer approach to SQL programming can make is easy to solve complex problems, and with much faster performance!

See here, how to use temporary tables to hypercharge SQL:

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

This approach has been very popular and it has led to a need for more knowledge of the complex internals of temporary tables.

- How to index a temporary table?

- How to customize CBO statistics on a temporary table?

- When to use dynamic sampling on a temporary table?

- How is a global temporary tables different than a WITH clause table?

- How to see the individual TEMP space used by a session's temporary table:

See these notes on secrets for temporary tables including:

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

For more complete details, I'm happy to report that after nearly three years of work, my new SQL Tuning book is now available for pre-order:

http://rampant.cc/cart/catalog/catalog/default.php?cPath=21&sort=2a&page=1&action=buy_now&products_id=185

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

And now for something completely different:

I always like to teach Oracle by analogy, and visualization can help a newbie understand Oracle concepts.

Have a gander at some of my more outlandish Oracle visual concapts:

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

You can join the thousands of subscribers to the Don Burleson Blog at this link:

http://dba-oracle.blogspot.com/

*****************************************
Need Oracle Training?

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 800-766-1884 for details, and check out our on-site Oracle training catalog at the following link:

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

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

There's Always Room at the Top

Burleson Consulting continues to grow as the Oracle community recognizes that high quality Oracle support and training is a cost effective option in these tough economic times.

If you have distinguished yourself in your Oracle career and are ready to step up and enjoy the rewards of joining the ranks of America's top tier support consultants we would like to hear from you.

Evidence of high achievement as an Oracle professional might include publication of books and articles for the Oracle community, achieving an advanced degree from a competitive university and seeking out hands-on experience with complex databases. See here for details and a full qualifications list:

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