Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Informix 14.10 Partial Indexes

  • 1.  Informix 14.10 Partial Indexes

    Posted Tue August 18, 2020 10:22 AM
    You may have seen our article here (as publicised in LinkedIn Informix groups):

    https://www.oninitgroup.com/faq-items/informix-14-10-partial-indexes

    @Roland Wintgen
     sent me feedback regarding a quirk he found if there are mixed page sizes: see "Caveats" at the end of the article. The stored procedure provided to suggest candidate index changes has been updated today to include the work-around.

    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------


  • 2.  RE: Informix 14.10 Partial Indexes

    Posted Fri August 21, 2020 08:54 AM
    Thanks Doug.
    Great article.

    Cheers,
    -Snorri

    ------------------------------
    Snorri Bergmann
    ------------------------------