Re: 8i - Joining with Temporary Tables

Very cute idea !

It would be interesting to set up a
few tests to see what happens if
two users are using the same
temporary table though -

    last one in wins ?
    cursor invalidation ?
    any chance of deadlock ?

--

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

Thomas J. Kyte wrote in message <8job7c$a3b$1_at_nnrp1.deja.com>...


>In article <962567053.10947.0.nnrp-14.9e984b29_at_news.demon.co.uk>,

>  "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>>

>> 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).

>>

>

>You just gave me an idea.  what about dbms_stats?   we can analyze the

>table (but that doesn't have any effect -- it'll come back with NULL

>num_rows and such) but we can write the stats we believe will be true

>into the DD using dbms_stats.  The following:

>