Re: SQL select via logicals

[David Morris <dmorris@xxxxxxxxxxxxx>]

>>> John Carr <74711.77@compuserve.com> 11/30 10:18 PM >>>

>RE: Re: SQL select via logicals

>I also think it would be good to have a mechanism to force the inspection
>of all indexes before deciding to Sort, or Copy the data or Build an Index
>on the fly. 

>But I can't imagine how they would implement it.  I can see a new parameter
>on OPNQRYF but can't see how they would implement it in SQL. Unless it was
>a system wide System Value.

>John Carr

A system value and option on CHGQRYA would be better than nothing.

We have had some problems with the optimizer.  In a few cases it used 
a logical  for months and then, for no obvious reason, it times out and 
consistently builds an access path.  When you don't know what the access 
plan was it is difficult to determine why it is no longer being used.  In these 
cases forcing the optimizer to look at possibilities would help.

David Morris


                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                  
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@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
+---