I haven't created a join logical file in a very very long time, which is
why I am asking for your help now. I posted my question last night and no
one has replied. (see below for original posting.)
I am joining 3 files together. When I CPYF ..... NBRRCDS(1) or create a
query without any selection criteria and press F5, I know I will not get
any records right now but it goes through the whole file of 1.7 million
records and takes a long time. Does the join logical file not create an
index that it can use and give me a result right away?
When I query my file, I can see the records go up by 20000 all the way to
the end of the file, which isn't good since there are so many records.
Subject: Poor Performance from join logical files
From: "Glenn Gundermann" <ggundermann@xxxxxx>
Date: Mon, 22 Oct 2007 23:31:14 -0400 (EDT)
I have defined a join logical file without using the Dynamic Select
keyword so I was expecting the access path to be built and and I was
expecting immediate response when doing a CPYF. On the contrary, it
dissappears for 20 minutes.
As a second question, is there a way to specify two different conditions
without using DYNSLT? For now, I have created two join logical files, one
for each condition.
This mailing list archive is Copyright 1997-2020 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