Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: temp tables

Re: temp tables

From: Chuck Kincy <ckincy_at_pitc.com>
Date: 1998/02/20
Message-ID: <35120158.524624293@enews.newsguy.com>#1/1

On Thu, 19 Feb 1998 17:40:33 -0600, dcrouch_at_quadris.com wrote:

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

I don't see anything wrong with it. Doing it individual users is more dicey, but it's cool for batch processes.

/cpk Received on Fri Feb 20 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US