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

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

--