Re: Strange Performance Behavior on INSERT INTO SELECT statement...

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 28 Apr 1999 21:19:26 +0100
Message-ID: <925330897.18518.1.nnrp-10.9e984b29@news.demon.co.uk>

Unfortunately EXPLAIN PLAN does not always tell the truth. Generate the trace file whilst running the INSERT, and running the CREATE.

Newer versions of Oracle include

STAT #n lines after statements complete. The newest versions of Oracle include execution path details, including the number of rows examined in the row set.

By looking at these lines ('fold' the file if necessary), you may find indications that the two access paths are different.

Please keep us informed of the results.

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

Ed Prochak wrote in message <7g6v2h$vh2$1_at_nnrp1.dejanews.com>...
>>
>> thanks for the reply: i've been really trying to work this one out.
>> I forgot to mention but did do a plan trace on both the select and
>> insert, and they were identical except the first line (which was the
>> insert of course).
>>
>> Do you have any other ideas that I might could try to narrow down
>> the source of the problem?
>>
Received on Wed Apr 28 1999 - 15:19:26 CDT