Re: TEMPORARY TABLE
- From: rjamya <rjamya@xxxxxxxxx>
- To: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- Date: Wed, 27 Oct 2004 15:01:37 -0400
We use GTTs that preserve data across commits ... that's when we
manually have to delete ... if you use only for transaction, you are
golden, but our requirements are different.
We do have indexes on GTTs, people routinely load tens of thousands of
rows at times, I guess dynamic sampling would get useful then.
Raj
On Wed, 27 Oct 2004 14:57:53 -0400, Mercadante, Thomas F
<thomas.mercadante@xxxxxxxxxxxxxxxxx> wrote:
> Raja,
>
> We don't even do delete's on this table - nothing. Oracle cleans it up for
> us at the end of each transaction.
>
> So I'd say you are doing extra work.
>
> And what kind of statistics do we expect the optimizer to use on these
> tables? It is a memory scratch-pad. I don't have any indexes on the table.
> So I expect Oracle do perform full-table scans on this thing.
>
> Maybe I'm lucky. It's working just fine for me.
>
> Tom Mercadante
> Oracle Certified Professional
--
//www.freelists.org/webpage/oracle-l
Other related posts:
