Informix: Dropping redundant indexes
Posted in 2026
This has just been published: https://www.oninitgroup.com/faq-items/dropping-redundant-informix-indexes <https://www.oninitgroup.com/faq-items/dropping-redundant-informix-indexes> Is there ever a purpose having an index on column(s) that lead another longer index? ------------------------------ Doug Lawry Oninit Consulting ------------------------------
Maybe to support a primary key or a unique constraint on the shorter column list? Or have they optimized things to the point that the longer index can satisfy the key/constraint? Mark ------------------------------ mark collins ------------------------------
Hi Mark. Yes indeed: the SPL therefore looks only at duplicate indexes. ------------------------------ Doug Lawry Oninit Consulting ------------------------------
OK. I didn't look that closely at the SPL to spot that. Mark ------------------------------ mark collins ------------------------------