Feb 9, 2015
DB2 SQL- Rules for Creating Index
DB2 SQL- Rules for Creating Index
Indexes will speed-up the performance. Before creating Indexs, the following rules can be considered.
Consider indexing on columns used in WHERE, GROUP BY, and ORDER BY clauses, as well as for UNION, INTERSECT, and EXCEPT statements.
Limit the indexing of very frequently updated columns.
If indexing an APPEND NO table without a hash, explicitly create a clustering index. Failure to do so will…
View On WordPress