6.9 Temporary Tables

 < Day Day Up > 



In years past in traditional relational databases temporary tables were created as shell structures to contain temporarily generated data, usually for the purposes of reporting. Oracle Database has the ability to create tables containing temporary rows. Rows created in temporary table objects are created locally to a session, somewhat managed by the database. It is more efficient to use Oracle Database temporary table objects in some circumstances. Creating traditional temporary tables, filling them, emptying them, and storing or deleting their rows is unlikely to perform better than Oracle Database temporary table objects.



 < Day Day Up > 



Oracle High Performance Tuning for 9i and 10g
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
Year: 2003
Pages: 164

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net