If you want to minimize performance degradation using query, provide good
statistical information to the optimizer with logical files.

Or you could rig ejection seats and shoot the users out the window if they
select/omit.






"John P. Walsh" <john_walsh@icdc.com> on 03/21/99 09:01:45 PM

Please respond to MIDRANGE-L@midrange.com
                                                              
                                                              
                                                              
 To:      "MIDRANGE-L@midrange. com"                          
          <MIDRANGE-L@midrange.com>                           
                                                              
 cc:      "Steve Augustin" <saugusti@vansystems.com>,         
          "Stephan_H_Augustin@Vansystems. com"                
          <Stephan_H_Augustin@vansystems.com>, "Sgt. John     
          Walsh" <sgt.walsh@icdc.com>(bcc: Danny Jahr/Lawson) 
                                                              
                                                              
                                                              
 Subject: Query Performance                                   
                                                              








Please advivse how to best minimize the performance degradation of
interactive queries on QINTER .  V3R7 on my machine.  I intend to conduct a
Query class this week and need to solve this issue if i can.  I have
essential operations working 24/7 so there is no downtime to take advantage
of.






+---
| 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].