Statistics Support on DGTTs
In DB2 UDB v7 there were no statistics collected on DGTTs. To improve their performance, DB2 UDB v8 adds support for the RUNSTATS utility over DGTTs. Application programmers can now invoke the RUNSTATS utility to update statistics about the physical characteristics of a DGTT and its associated indexes. There is no change required for the syntax of the RUNSTATS command. Just ensure that you identify the DGTT with the SESSION schema as with all other operations on these tables.
For example, to collect statistics on the table we created earlier in this chapter, you could enter a command similar to the following:
runstats on table session.indextemptable on columns (id)
DB2 UDB v8 does not support the viewing of statistics ...
Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
