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