EVIs have been around at least since V5R1, can you say more about what
matters about V5R4 and SQE? CQE also uses EVIs where it deems it
On 3/8/2012 7:10 AM, Jim Oberholtzer wrote:
> It is V5R4 so be sure you are using the SQE instead of the CQE!.--
> Jim Oberholtzer
> Chief Technical Architect
> Agile Technology Architects
> On 3/8/2012 6:26 AM, Vern Hamberg wrote:
>> Feel free to create the EVI indexes - they are useful for selectivity
>> and joining - they don't do anything for sorting. The optimizer uses
>> them for bitmap processing.
>> On 3/7/2012 5:30 PM,elehti@xxxxxxxxxxxxxxxxxx wrote:
>> -->>>> On our V5R4M5 system (IBM i o POWER6), finally using System i
>>>> Navigator: SQL Plan Cache Snapshots; using Visual Explain for Index
>>>> When it recommends a Binary Radix index, I am creating one.
>>>> When it recommends an encoded vector index (EVI), I am not doing so yet,
>>>> but am researching the matter in the
>>>> IBM White Paper " IBM DB2 for I indexing methods and strategies - Learn
>>>> how to use DB2 indexes to boost performance"
>>>> This white paper lays the foundation for an indexing strategy and design
>>>> that delivers high-performance queries and SQL applications on IBM DB2
>>>> for i. Both, programmers and database administrators can find
>>>> information on indexing to make their jobs easier and improve the
>>>> performance of their DB2 for i servers. This in-depth discussion on DB2
>>>> for i indexing includes a description of the technology along with
>>>> coverage of the DB2 performance tools available to assist with index
>>>> analysis and SQL performance tuning.