Re: Global Temporary Table performance with inserts.

Hector wrote:

> I am using an Oracle Temporary table to generate a tree of data
> dependencies. I noticed that Inserts are significantly longer into the
> Temporary table than if I replaced the Global Temporary Table with a
> permanent table (just as a test case), almost by a factor of 50. The
> number of rows being inserted are approx. 100. Has any one experienced
> this issue and what are the workarounds? I am using Oracle 8.1.7 and
> have created the Global Temporary Table with "on commit preserve rows"
> clause. Thank you for your help in advance.

I've never seen this behavior. And with 100 rows I'm quite frankly amazed you can detect the time required at all. But do you really need the "on commit preserve rows"?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)