Informix 14.10 Partial Indexes

Posted in 2020

Topics: Stored Procedures & SPL, Server Administration

Doug Lawry — source: IBM Community (ConnectedCommunity.org) Informix forum

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 ------------------------------ #Informix

↪ replying to Doug Lawry

Snorri Bergmann — source: IBM Community (ConnectedCommunity.org) Informix forum

Thanks Doug. Great article. Cheers, -Snorri ------------------------------ Snorri Bergmann ------------------------------