RE: Implicit Access Path Sharing

Brad,

At 08:47 AM 4/28/99 -0500, you wrote:
>Then the question is, if you already had LF1 with A & B as keys (and no
>selects, etc), why would you create LF2 with A as a key?  That's redundant
>to begin with and does you no good assuming there are no other criteria
>needed by either logical.

 This is in a shop that has a fair amount of Synon generated code.  Synon
automatically creates two "primary key" logicals, one for retrieval and one
for update.

 -mark

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