|
I have found that I like STRSQL for optimizing my SQL's manually. I can make an SQL run faster buy finding out bottle necks using tools to display them and then manually tweaking the SQL for desired performance. Granted, this is for multiple join SQL's. It is till fun to see when a small change in the SQL results in a 1min performance boost. :) I have not found a tool yet that can create an SQL that can run faster than one that I have create in this way. Bryan -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Tuohy Sent: Monday, July 11, 2005 11:19 AM To: Midrange Systems Technical Discussion Subject: Re: Steve Ballmer says IBM is not innovating lately Or better still, use the Databases function in iSeries navigator to actually create the tables, views etc. Use Run SQL Scripts to test it, use Generate SQL to generate an amendable script. Why use STRSQL? Paul
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.