Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Schaumburg, IL

    Unanswered: IBM DB2 UDB V8 Type 2 indexes


    I am doing some research on type 2 indexes in V8.

    I am attaching whatever I have found as a ppt attachment.

    However, I need some more information. If somebody out there has done some R&D on this particular feature, please share it with me. It will be of great help.

    I am looking for the following:

    1. Brief overview of Type II index
    2. How type II is used by other fetaures of UDB V8
    3. Any test results indicating a performance benefit over type 1 indexes as found in V7.2

    I will update the ppt presentation and will post it on the forum after I have a complete presentation.

    Thanks in advance,
    Attached Files Attached Files
    Naveen Urs
    DBA Manager
    IBM Certified Solutions Expert - DB2 LUW V7, V9

  2. #2
    Join Date
    Aug 2003

    Re: IBM DB2 UDB V8 Type 2 indexes

    One more point to add :

    Use INSPECT Command to identify the index type

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts