Re: Encoded Vector Indexes -EVI's

[Pete Hall <pbhall@xxxxxxxxxx>]

At 22:14 02/28/2000 , Peter Marr wrote:

>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)?

I'll leave the definitive answer to that one to one of the IBM folks. I do 
recall seeing an article that quoted benchmarks showing that they are 
almost as efficient as creating explicit custom indexes to support joins. 
Just be certain that you are up to date on your PTFs. Up until 60-90 days 
ago, there were many problems with join processing using EVIs, at least at 
V4R3. That situation seems to have stabilized now and life is good. BTW, 
that is create index. A view is only concerned with the data space, not the 
access path.


Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall
+---
| 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
+---