Re: Encoded Vector Indexes -EVI's

[JFinney@xxxxxxxxxxx]

Hi Peter,

Yes, they are only available through the SQL interface and, as such are
read only (ie. you can't currently use them in RPGLE programs). I don't
know enough about them to know what it takes to be able to perhaps include
them in programs (eg. for insert or update or read) but they make a massive
difference when using query/400. Very quick. The query optimizer
automatically finds the relevant logical (EVI) to use.

Ragards
John.





"peter marr" <pmarr@conrad.com.au> on 29/02/2000 04:14:49

Please respond to MIDRANGE-L@midrange.com

To:   MIDRANGE-L@midrange.com
cc:    (bcc: John Finney/ITS/Omnia Group)

Subject:  Encoded Vector Indexes -EVI's





Is anyone using EVI's or have some knowledge they would like to share about
them? Pro's & Cons.
Are they only available in when creating SQL INDEX(view)?

Regards,
Peter Marr.

pmarr@conrad.com.au


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---






+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---