RE: MIDRANGE-L Digest, Vol 5, Issue 1682

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

"Since adding indexes can sometimes have adverse effects on some base
code"

Huh?

Since when, what adverse effect?

If you add lots of indexes on a volatile file, you could see a
performance hit due to index maintenance.  But other than that, I'm not
aware of any "adverse effects" indexes might have on base code.

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Holden Tommy
> Sent: Wednesday, September 06, 2006 9:27 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: MIDRANGE-L Digest, Vol 5, Issue 1682
>
>
> If only I could...in our shop our main software package is a 3rd party
> software & the mandate is to not change or customize the base product
> unless it's just a "have-to" case.  Since adding indexes can sometimes
> have adverse effects on some base code it's just not always a viable
> solution (not arguing at all..In fact I support index usage
> whole-heartedly...) unfortunately some of us have to march to the beat
> of someone else's drum =(
>
>
> Thanks,
> Tommy Holden