The access path will be shared only if the select/omit logic is dynamic -- 
unless the logical in question has identical s/o criteria. 

Which leads to an interesting question: If I have 2 logicals, one keyed Fld1, 
Fld2 with STATIC select where Fld3 = 'C' and the other keyed Fld1, Fld2 with 
DYNAMIC select where Fld3 = 'C' will the second logical share the access path 
of the first?

-Walden

> -----Original Message-----
> From: mcsnet!midrange.com!midrange-l-owner@Mcs.Net
> [SMTP:mcsnet!midrange.com!midrange-l-owner@Mcs.Net]On Behalf Of Al
> Barsa, Jr.
> Sent: Sunday, December 14, 1997 3:17 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: Logical file index size too small?
> 
> 
> At 01:05 PM 12/10/97 -0500, you wrote:
> >Hello again!
> >
> >We've got a physical file with 2.7 million records and 10+ 
> >logical files built over it.  In an attempt to speed up
> >processing, we're analysing which logicals we can eliminate.
> >While doing a DSPFD, I noticed that the index size for some
> >of these logicals is really small: 16384.  This doesn't
> >make any sense because the key length is 36 bytes: I'm
> >expecting something closer to 95 megs!
> 
> The small logical file is sharing an access path with another logical.  It
> could be a redundant file, or it could use the same sort criteria with
> select/omit logic.
> 
> 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
> +---
> 

winmail.dat


This thread ...

Replies:

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