Re: Encoded Vector Indexes

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

----- Original Message ----- 
From: "Vern Hamberg" <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, October 23, 2003 19:46
Subject: Re: Encoded Vector Indexes


> Jerry, EVIs are a different kind of index, as you know. They cannot be
used
> for ordering records, only for record selection. This could be a reason to
> keep the non-EVIs, if they are used to support an ORDER BY. Also, I don't
> know whether and EVI index can be used in RPG, as a logical file can.

No, they can not be used in an RPG program.

> EVIs are cool and performance is supposed to be better in V5R2 - there
were
> some problems earlier. No details, just scuttlebutt.


Yes, pure scuttlebutt, I've used them since they were released, and have had
nothing but success with them.



===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"If you pick up a starving dog and make him prosperous,
  he will not bite you. This is the principal difference
  between a dog and a man."

    - Mark Twain