×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On 04 Mar 2013 11:55, Stone, Joel wrote:
If one row advises to add (FieldA , FieldB), and a second row
advises FieldA for the same file, would adding a logical file
with keys FieldA & FieldB do the trick for both advising rows?
In most cases, the one Access Path with both columns as keys is
probably the best. There are likely some cases where the /baggage/ of
the extra column FieldB in the Keyed Access Path could discourage the
choice of that AccPth by the optimizer for query implementation.
Does creating a LF benefit the same as adding an index?
A Keyed DDS LF can have the same benefit as a SQL DDL CREATE INDEX
when creating the /same/ Keyed Access Path. For just keyed columns, the
typical keyed DDS LF will be created with PAGESIZE(8) by default, per
the default specification of PAGESIZE(*KEYLEN), for which the optimizer
would tend *not* to choose that AccPth for implementation except perhaps
in limited memory environments; i.e. the larger page sizes [64+] are
preferred by the query engines. The default page size for SQL [i.e.
PAGESIZE 64] is what is the preference for the query engines as the minimum.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
