Re: TEMPORARY TABLE

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_at_labor.state.ny.us> 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

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