RE: EVIs

You want the EVI built over the select part of the statements, not the order
by.  This makes the ODP be used.

If you run the application in debug mode it will give you access path
recommendations.  You can use these to build your EVIs.

Brad

> -----Original Message-----
> From: Debbie.Moore@RCIS-NET.COM [mailto:Debbie.Moore@RCIS-NET.COM]
> Sent: Thursday, March 01, 2001 2:32 PM
> To: RPG400-L@midrange.com
> Subject: EVIs
> 
> 
> I am looking for information on Encoded Vector Indexes.  
> Supposedly these
> are useful in data warehouse type situations where the tables 
> are large and
> there are a relatively small number a distinct key values in 
> the table.  
> The problem was that we removed the LFs and created the EVI.  
> Then when
> running a RUNSQLSTM or using our Data Warehouse Query Tool,  
> the vector
> index did not get used.  Instead the ODP was created during 
> the run, causing
> it to be dreadfully sluggish.
> Any ideas on what can be done for this?
> 
> Debbie Moore
> * * * * *
>      2249
> 
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---