OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4

Chapter 2. DB2 for i5/OS performance basics 15

Create EVIs on:

򐂰 Read-only tables or tables with a minimum of INSERT, UPDATE, and DELETE activity

򐂰 Key columns that are used in the WHERE clause: local selection predicates of SQL

requests, and fact table join columns when using Star Join Schema support

򐂰 Single-key columns that have a relatively small set of distinct values

򐂰 Multiple-key columns that result in a relatively small set of distinct values

򐂰 Key columns that have a static or relatively static set of distinct values

򐂰 Nonunique key columns, with many duplicates

Create EVIs with the maximum bytecode size expected:

򐂰 Use the WITH n DISTINCT VALUES clause on the CREATE ENCODED VECTOR INDEX

statement.

򐂰 If unsure, consider using a number greate ...