Re: Recommended SQL Indexes -- MIDRANGE-L

Subject: Re: Recommended SQL Indexes
From: Gerald Kern <jp2558@xxxxxxxxx>
Date: Tue, 13 Dec 2016 15:42:23 -0500
List-archive: <http://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

What I've always done is run an RPG program using the desired sql statement
(loaded into a variable) in debug mode. Then refer to the job log and you
will see a lot of good information. One of the benefits of doing this is
that you can restructure the SQL statement (order of fields selected, order
by clause etc) on the fly and compare the results.

Note that you will need to change the job to set the JOBMSGQFL parm on the
job to *WRAP otherwise you will fill the job log and the program will abend.

As an Amazon Associate we earn from qualifying purchases.

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.