RE: Long process time

EVI - Encoded Vector Index.  It contains information on how many records for a 
specific key are contained in a table.  It is used by the SQL optimizer to help 
determine the best way to implement a query.  Depending on your file size they 
can be rather large.

If you want to know more take a look at the SQL reference manual at the 
InfoCenter.
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm

What about some of the other suggestions?  Have you tried any of those yet?

Rick

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Dwayne Allison
Sent: Wednesday, December 08, 2004 12:59 PM
To: Midrange Systems Technical Discussion
Subject: RE: Long process time


Sorry I never used or heard of EVI.  How does it work?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Mike savino
Sent: Wednesday, December 08, 2004 12:10 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Long process time


Would this be a good situation to try an EVI?  My understanding is that they
are specifically designed to speed up Data Selection where the Selected On
field has a limited number of values.  That appears to apply to your
situation.  I'm just not clear if it works with OPNQRYF or only works with
SQL.  MC Press Online had an article on this not too long ago.

Mike


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain legally 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.