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.


This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].