Re: Can an SQL common table expression be used for many different selects? -- RPG400-L

Subject: Re: Can an SQL common table expression be used for many different selects?
From: Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
Date: Wed, 29 Jul 2020 11:05:44 -0500
List-archive: <https://archive.midrange.com/rpg400-l/>
List-help: <mailto:rpg400-l-request@lists.midrange.com?subject=help>
List-id: RPG programming on IBM i <rpg400-l.lists.midrange.com>
List-post: <mailto:rpg400-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=unsubscribe>

+100 on selecting the most effective solution regardless of elegance and documenting it. My mentor always told me, "Never let the perfect be the enemy of the good".

On 7/29/2020 10:56 AM, John Yeung wrote:

Honestly, if you were to just include copious comments explaining
"hey, yeah, this code is ugly, but we need it to run as fast as
possible, and this is the way that we've found runs the fastest", to
me that is perfectly fine.

John Y.

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Can an SQL common table expression be used for many different selects? , Jon Paris

This mailing list archive is Copyright 1997-2025 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.