IBM Books

Administration Guide


Table Space Impact on Query Optimization

Certain characteristics of your table spaces can affect the access plan chosen by the SQL compiler:

The following shows an example of the syntax to change the characteristics of the RESOURCE table space:

    ALTER TABLESPACE RESOURCE
      PREFETCHSIZE 64
      OVERHEAD     19.3
      TRANSFERRATE 0.9

After making any changes to your table spaces you should consider rebinding your applications and use the RUNSTATS utility to collect the latest statistics about the indexes to ensure the best access plans are being used.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]