The process of creating indexes on large tables can have a detrimental effect on a DB2 system.
Traditional index-building tools, such as CREATE INDEX, are slow and the CPU time involved is expensive.
In addition, the volume of data and elapsed time required for sorting can cause DSNDB07 lockouts to applications unrelated to the indexed table. With CA’s Fast Index, you can build indexes in a fraction of the time required by other tools, so there’s virtually no impact on your DB2 system resources.
|
