MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2013

Re: SQL created table slows reporting tool



fixed

The caution about indexes willy-nilly applies to both SQL indexes and DDS
logical files. The basic caution is that indexes put maintenance on the
system. For example, if you have 200 indexes on one physical file then
every time you add a row to that table it has to update all 200 indexes.
This used to be pounded in our heads. I'd mention the IBMer, he deserves
the credit, but too many would drift off into a geezerfest. This concern
is supposed to be somewhat alleviated by newer versions of the OS. Many
names, long respected in the industry, have said so. However there are
those who will reply that they do not care what those people say - when
they reorg a large table with a lot of indexes it runs much longer than
deleting all the indexes first.

Keeping that concern in mind, I think you would be SAFER to use the sql
indexes recommended by iNav over the DDS logical. The temptation to put
stuff in the logical file that really shouldn't be there would be
eliminated. That, and SQL tends to use more modern defaults, such as page
size and whatnot. While DDS tends to carry over defaults best left behind
when we all migrated off of AS/400's.

It's up to you to communicate with your change management vendor to see
how they could capture such a creation, and if not, how to best put this
into the process.

Rob Berendt





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact