Skip to main content

Index Advisor Surfaces Maintained Temporary Indexes Activity on DB2 for i5/OS

Web Doc

Note: This is publication is now archived. For reference only.


Published on 08 August 2006, updated 12 August 2008

  1. View in HTML

Share this page:   

IBM Form #: TIPS0624

Authors: Hernando Bedoya

    menu icon


    DB2® for i5/OS® on V5R4 provides features and tooling to define, test, and improve index strategies. With the addition of Maintained Temporary Index (MTI) detail, the user can better understand temporary indexes and their effect on system performance.

    Written by Scott Forstie

    SQL development leader

    IBM® DB2 UDB for i5/OS



    Special Notices

    The material included in this document is in DRAFT form and is provided 'as is' without warranty of any kind. IBM is not responsible for the accuracy or completeness of the material, and may update the document at any time. The final, published document may not include any, or all, of the material included herein. Client assumes all risks associated with Client's use of this document.