Re: SQL and File analysis

[fkolmann@xxxxxxxxxxxxx]

Kusman Lim wrote:

> What Need I do with BPCS Performance if I know the most index use which
> not index ?
>
> BPCS 6002plf cum macrh 98
>
> Kusman Lim

You need to create a LGL file with a key/s that matchs the SQL WHERE fields,
also it there is an ORDER BY you will need another LGL.  Its is not always
possible to set up LGL files as needed by SQL particularly the multi file
JOINS that need fields from secondary files as prt of the key/s.



+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---