Re: Procedure Performance Suggestion

On 22 Mar 2002, tkyte_at_oracle.com wrote:
> In article <a7fke4$be6$1_at_reader1.panix.com>, "R says...

>>
>>I have a procedure that builds the SELECT and uses Native Dyn. SQL
>>(execute immediate) to populate a table for report....

[...]

> create the table ONCE and reuse it over and over. My suggestion --
> use a GLOBAL TEMPORARY table with on commit delete rows and

Tom,

Won't the global temporary table lose data once the session is gone? How would this help if he's populating it for a report that someone else might run?

The rest of your post is, of course, correct, but I'm not sure of the temporary table idea for Rob.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.