• Subject: RE: Query Optimizer
  • From: PaulMmn <PaulMmn@xxxxxxxxxxxxx>
  • Date: Sat, 6 Nov 1999 11:27:46 -0500

>The optimizer can be pretty *&%$ stupid at times.  There are situation when
>I *know* that a certain logical would work just dandy, but the optimizer
>builds a temporary index anyway.  Sometimes I could write, compile, and run
>an RPG program to do the same thing in less time than it takes for the index
>to build.  :(

>Southern Wine and Spirits, Inc.

Our resident Query guru has done magical things with Query and large files.

The most important rules are:

        (1) Your first queries must select/omit records from immense files
to work files

        (2) DO NOT SORT as you select records from immense files.

By following these 2 rules (and using intermediate work files and multiple
queries) he has been able to reduce query processing time from days (well,
hours) to minutes.

--Paul E Musselman

| 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

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].