RE: Temporary Tables - 3 of 3

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of GovindanK
Sent: Friday, August 26, 2005 2:16 PM
To: rjamya
Cc: Meenakshi.Aggarwal@xxxxxxxxxxxxx; 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@xxxxxxxxx> said:
> Govindan, interesting observation, would you elaborate why you'd 
> choose object over GTT ??
> 
> Raj
> 
> On 8/26/05, GovindanK <gkatteri@xxxxxxxxxxx> 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@xxxxxxxxxxxxx> 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

Other related posts: