| < 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 > |
|