It is V5R4 so be sure you are using the SQE instead of the CQE!.
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.