Re: SQL select via logicals

[Vernon Hamberg <hambergv@xxxxxxxxxxxxxx>]

Walden

At 06:28 PM 11/26/1997 -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
>
>PS. V3R1

><snip>
>>For it to use the logical, it has to be able to determine that it's select
>>criteria is narrower than the logical.
>>
>>Al
><snip>

But in your case, your select criteria is _broader_ than that of the
logical, since it's asking for everything.

Cheers

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480


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