Re: Alter index to cluster

Choose the one for which your queries are most likely to want to scan the table in index order... It also alters the data layout so that your data is in the same order as the key values in the clustered index. Also, use a UNIQUE index if at all possible, or the one with the least duplication. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From: "Dan Madvig - Bethel College & Sem." <daniel@genesis.admin.bethel.edu> }Date: Wed, 14 Feb 96 12:42:26 CST }X-Informix-List-Id: <list.8723> } }Greetings from tropical Minnesnowta! } }I have used the process "alter index so_and_so to cluster" and }then "alter index so_and_so to not cluster" to reduce the number }of extents for the table associated with the index. } }Does it make much difference in performance (or otherwise) if I }choose a single column index or a multi-column one? If not, I'd }just go with the first one I come to.