Re: EXPLAIN PLAN

From: Tad Davis <davist_at_umis.upenn.edu>
Date: 1997/01/28
Message-ID: <5cl5sr$7ga@netnews.upenn.edu>#1/1

B C Zygmunt (bzy_at_ornl.gov) wrote:

: I am going to answer my own question on this. I determined just after sending
: the previous message that the sequence of the tables is one of the key factors
: in query speed. That is, in the query below, since I am going to join lab_meas
: and lab_smp, I want them next to each other. The same for lab_smp and sample,
: and so on. (It does appear that small tables can be stuck off anywhere.)

Which version of Oracle are you running? We were told, in our "tuning" class, that this made a difference for Oracle 6 but was not SUPPOSED to make a difference for Oracle 7, when using the cost-based optimizer.

--
Tad Davis                  215-898-7864 voice
(davist_at_isc.upenn.edu)     215-898-0386 fax

Received on Tue Jan 28 1997 - 00:00:00 CST