Re: Encoded Vector Indexes -EVI's

["Eric N. Wilson" <doulos1@xxxxxxxx>]

EVI Indexes can only be made via SQL and they certainly do help in many ad
hoc query executions. Most information I have read says to create an EVI for
each  field that you feel there may be selection on. It certainly has made
our Data Warehousing application sing! Mainly due to the fact that EVI
indexes are similar to bitmap indexes (but much superior) and can therefore
be ANDed and ORed and XORed together so that I/O is dramatically reduced.
From what I have read they can also help in COUNT() type queries.

______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St.
Tacoma WA 98407


----- Original Message -----
From: "peter marr" <pmarr@conrad.com.au>
To: <MIDRANGE-L@midrange.com>
Sent: Monday, February 28, 2000 8:14 PM
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
+---