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


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