Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: temp tables
Temp tables are only OK in Oracle if after the work is done, you delete the tables and then coalesce the tablespace. Why not create a workspace tablespace, permanently create the intermediate tables, and then truncate them each time after the work is done. That way, the overhead of creating the table is gone, unless you are creating the tables "unrecoverable".
AEV
dcrouch_at_quadris.com wrote in message <6cifth$4t5$1_at_nnrp1.dejanews.com>...
>I am running a nightly batch procedure that contains some nasty nested
update
>queries. I was having some performance trouble so I broke out the nests
and
>had them form temp tables first. then queried off the temp tables. Is this
a
>good solution?
>
>Dennis Crouch
>dcrouch_at_quadris.com
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Feb 20 1998 - 00:00:00 CST