RE: SQL select via logicals

["Brian Lawson" <BLawson@xxxxxxxxxxxxxxx>]

Sorry, but I think that this is the way that it was intended to work!  I 
believe that you are mis-interpreting the rulls that the query optimizer 
follows.  The optimizer will optionally select a logical view if, within a 
certain period of time, it determines that this logical view gets to the data 
faster.  

What you are doing is telling Query to return the records from an existing 
logical view.  It wouldn't make sense for it to then read the physical and 
return ALL of the records from it when some where omitted from the logical.

HTH.

Regards,
Brian Lawson
HJM Systems, Inc.


-----Original Message-----
From:   Al Barsa, Jr. [SMTP:barsa2@ibm.net]
Sent:   Thursday, November 27, 1997 10:32 PM
To:     MIDRANGE-L@midrange.com
Subject:        Re: SQL select via logicals

At 06:28 PM 11/26/97 -0500, you wrote:
>This is what I thought. But in my example I have no where clause (I want all
>records) but only those in the access path are returned. Strange.
>
Walden,

I would report this as a possible database bug.

Al




Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:  914-251-9400
Fax:    914-251-9406





Private mail should be sent to barsa@ibm.net
+---
| 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
+---


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