RE: join file in query400

["Van Rensburg, Lukas" <LVanRensburg@xxxxxxxxxxx>]

Title: RE: join file in query400

It is normal. Query tries to use existing access paths but if none found it builds an access path. Use retrieval access paths when joining for both files and not physical.

-----Original Message-----
From: Joel Fritz [mailto:JFritz@sharperimage.com]
Sent: Tuesday, February 15, 2000 5:38 PM
To: MIDRANGE-L@midrange. com (E-mail)
Subject: join file in query400

I've never done too much with join files, so this may be just my
inexperience.  I created a join between our sales and orders
files in order
to facilitate calculating orders net of returns. (Orders are in
the orders
file and returns are in the sales file.)  I'm running a query
as I type that
is collecting net orders for a group of products.  I'm running it
interactively (F5) and have been staring a message that
announces that the
query is building a copy of the join file.

Is this normal behavior.  Both of the files that are joined
have buckets for
13 weeks of various kinds of data for each store for every item
code.  (It's
made for reports, not transactional data.)

Is this peculiar?  Sure took a long time.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---