Creating Indexes

Posted in 2012

Topics: Versions, Editions & End-of-Life

SUSAN JONES — Tue, 20 Nov 2012 15:22:39 — source: IIUG Forums & Mailing Lists

I have what I hope is a simple question. When creating indexes, If I create an index on a column that has null values, are those values included in the index and is it a good idea to create indexes on columns that contain null values? Listed below are the versions of Informix we are currently running along with the OS version. Server 1 IBM Informix Dynamic Server Version 11.50.FC9 AIX 5.3 Server 2 IBM Informix Dynamic Server Version 11.70.FC6 AIX 7.1 Thanks, Susan Jones

↪ replying to SUSAN JONES

SUSAN JONES — Tue, 20 Nov 2012 15:25:54 — source: IIUG Forums & Mailing Lists

I just notices someone else recently posted the same question that many of you have already responded to so you can disregard this post. Thanks, Susan Jones