Re: Temporary Tables - 3 of 3
- From: rjamya <rjamya@xxxxxxxxx>
- To: Igor Neyman <ineyman@xxxxxxxxxxxxxx>
- Date: Fri, 26 Aug 2005 15:03:51 -0400
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
> > > > --
> > > > //www.freelists.org/webpage/oracle-l
> > > --
> > > //www.freelists.org/webpage/oracle-l
> > >
> >
> >
> >
> > --
> > ------------------------------
> > select standard_disclaimer from company_requirements where category =
> > 'MANDATORY';
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
Other related posts:
