Re: 8i - Joining with Temporary Tables

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/07/02
Message-ID: <962567053.10947.0.nnrp-14.9e984b29@news.demon.co.uk>#1/1

Whoops, lack of precision in what I said. Let me rephrase my comment:

You can run the analyze command against temporary tables, but it doesn't actually do anything (unless you have used the extensibility feature to add your own indexing methods).

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Martin Haltmayer wrote in message <395F3946.D06F02F3_at_0800-einwahl.de>...


>Of course you can analyze them without loosing their contents if you

 created


>them with "on commit preserve rows":

>

>

>Jonathan Lewis wrote:

>>

>> Unfortunately you have hit the very point

>> that makes temporary tables a bit of a pain.

>> You cannot analyze them, so Oracle can

>> generate some totally atrocious plans when

>> you mix temporary and permanent tables.

Received on Sun Jul 02 2000 - 00:00:00 CDT