Re: Temporary Tables - 3 of 3

if it is solely because of memory processing being faster, then we should be 
using in-memory databases. I like GTTs because they provide more 
flexibility, if I am using 10 rows or 10m rows. It is just like another 
table ... no casting required.

Raj

On 8/26/05, Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote:
> 
> 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
> 
> 


-- 
------------------------------
select standard_disclaimer from company_requirements where category = 
'MANDATORY';

Other related posts: