Re: Program seems very slow

From: Phil Cook <pcook_at_iamerica.net>
Date: 1997/08/12
Message-ID: <01bca729$1ef98ce0$73f9adcd@phil-cook-laptp>#1/1

Bruce,

There are a number of resources that could be constraining your process, but the first place I would check is to see if there is an index that contains
all of the values in your where clause, i.e. number1, number2, etc.. Look at the data dictionary view all_ind_columns.

Phil Cook

Bruce Bristol <bbristol_at_ix.netcom.com> wrote in article <33ED2CCC.59E1_at_ix.netcom.com>...
> I have a COBOL program that simply reads a file and checks each record
> against our History Database to see if it's already been processed.
Received on Tue Aug 12 1997 - 00:00:00 CDT