That's true too!


----- Original Message -----
From: <Jderham2@xxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, March 25, 2004 9:42 AM
Subject: Re: Query optimizer tells me to build an access path that

> In a message dated 3/25/2004 3:54:46 AM Eastern Standard Time,
> Clare.Holtham@xxxxxxxxxxxxxx writes:
> > That's one of the indexes you ALWAYS want to build. The Optimizer may
> > use it for statistics (data skew). Or it may want to use an index from
> > access method or whatever.
> > Or do you mean you have already created the index? That can happen too.
> > the optimizer looks for an index, it may use different criteria or time
> > before it gets to the right one. These rules are different depending
> > version of the OS/400 you have. Sometimes it searches fifo, sometimes
> > other way, etc.
> > If the file is really huge you could also try creating an EVA index.
> > If you are on V5R2 there are now two different SQL Optimizers with
> > rules, and a new statistics gatherer.
> > If you're in the US, I believe IBM do workshops on this subject....
> >
> > cheers,
> >
> > Clare
> >
> > Clare Holtham
> > Director, Small Blue Ltd - Archiving for BPCS
> > Web:
> > IBM Certified AS/400 Systems Professional
> Rumor has it that if you create the index with SQL rather then with DDS
> the SQL will like it more better.
> Jack D.
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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