Re: Implicit Access Path Sharing

[Mark Lazarus <mlazarus@xxxxxxxx>]

Larry,

At 01:02 AM 4/28/99 -0400, you wrote:

>   I don't believe the format name has any effect. For example it you
>have a PF with fields 'A' through 'F'.  LF 1 has keys 'A' and 'B' and
>includes fields 'A' 'B' 'C' and 'D'.  LF 2 with keys 'A' and 'B' but
>selecting fields 'A' 'B' 'E' and 'F' would still share the access
>path.  Remember that the access paths select and sequence ROWS. 
>Column selection is independant of the access path.  We RPG types tend
>to equate access paths with LF and this is not the case.

 Try this:

 Create a *LF specifying the fields explicitly (just include from the *PF's
DDS).  Pick any key(s). Then create a copy of this *LF's DDS.  Compile both
and see if they share access paths.

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