Re: System i Navigator: SQL Plan Cache Snapshots; using Visual Explain for Index Advisor, to improve QZDASOINIT SQL performance

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:

Eric

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.

Vern

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
Advisor.
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"
Excellent.

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.

--