Re: Query Performance

[Danny.Jahr@xxxxxxxxxx]

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