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.
>

--