|
|
| Re: Temporary table in Oracle [message #411570 is a reply to message #411553] |
Sun, 05 July 2009 08:38   |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
I found it a bit ranty. It doesn't so much tell you about temporary tables as the myriad ways in which the author has seen them mis-used.
Having said that, I am going to cop out and decline to improve upon it.
For what its worth (very little, I expect), I'd keep the Introduction and rewrite the remaining sections to discuss:
- Purpose of Temporary Tables (store a working copy of data that can be indexed and accessed via SQL)
- Other methods of storing working data sets (PL/SQL collections accessed procedurally, Object Type collections accessed via SQL, heap tables)
- A detailed comparison of the methods (eg. redo/undo generation, relative read and update efficiency, limitations, scaleability)
- Some common scenarios benchmared with each method including scaling factors
- Some pitfalls (as already detailed) but benchmarked and shown with work-arounds
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
