Re: Question about Encoded Vector Indexes (EVI)

[Tony Carolla <carolla@xxxxxxxxx>]

If you create SQL views, which basically become on-demand Logical files, and 
then you use those views in queries, or even RPG, they can use EVIs. I do 
this, and I don't have the SQL developer package. The trick is when to use 
one of them, vs. a traditional index. 

On 6/6/05, Karen L Hodge/MIS/Genesys <KHodge@xxxxxxxxxxx> wrote:
> 
> 
> 
> 
> 
> 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.
> 
>