RE: Question about Encoded Vector Indexes (EVI)

Karen,

I believe improvements due to the use of EVI's are limited to the newer SQL 
based interfaces.

OPNQRYF and Query/400 don't benefit.


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

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Karen L
> Hodge/MIS/Genesys
> Sent: Monday, June 06, 2005 10:55 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: Question about Encoded Vector Indexes (EVI)
> 
> 
> 
> 
> 
> 
> I have just learned about the existance of EVI's and am really excited
> about what I have heard.
> 
> Can anyone tell me:
> 
>  Is the improvement in performance limited to SQL and OPNQRY or will
> queries created in WRKQRY use the EVI?
> 
> 
> Thank you,
> 
> Karen Hodge
> Senior System Analyst
> Genesys Health System
> 1000 Healthpark Blvd, Grand Blanc, Mi 48439
> Office 810.606.5180, Fax 810.606.7204
> khodge@xxxxxxxxxxx
> 
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
>