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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Temporary Tables - 3 of 3

RE: Temporary Tables - 3 of 3

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Fri, 26 Aug 2005 14:58:50 -0400
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A237ED95@EXCHANGE.corp.perceptron.com>


Temporary tables will be also "in memory" if they fit sort_area. And, "on commit preserve/delete" only adds flexibility to temporary table, which speaks in their favor.

Igor Neyman

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of GovindanK Sent: Friday, August 26, 2005 2:16 PM
To: rjamya
Cc: Meenakshi.Aggarwal_at_fishersci.com; oracle-l Subject: Re: Temporary Tables - 3 of 3

Memory processing is any time faster than table handling. Lesser maintenance.
As i have mentioned in 1 of 3 and 2 of 3 one need not have to bother about on commit preserve/delete.
You can select multiple times within the same session and the values are avbl to you.

HTH
GovindanK

On Fri, 26 Aug 2005 12:41:05 -0400, "rjamya" <rjamya_at_gmail.com> said:
> Govindan, interesting observation, would you elaborate why you'd
> choose object over GTT ??
>
> Raj
>
> On 8/26/05, GovindanK <gkatteri_at_fastmail.fm> wrote:
> >
> > If it does not involve too much of volume i would prefer creating an

> > object type, assiging values to it and select CAST from it.
> >
> > HTH
> > GovindanK
> >
> > On Fri, 26 Aug 2005 11:52:23 -0400, "Aggarwal, Meenakshi"
> > <Meenakshi.Aggarwal_at_fishersci.com> said:
> > > Does anybody know any reason of not using temporary tables in
Oracle 9i.
> > >
> > > Thanks
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>
>
>
> --
> ------------------------------
> select standard_disclaimer from company_requirements where category =
> 'MANDATORY';

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 26 2005 - 14:01:13 CDT

Original text of this message

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