Re: about index

Posted in 1997

Jonathan Leffler — 10 Feb 1997 14:08:29 -0500 — source: Informix-list mailing list archive (1991-1998)

>From: Paolo Mancuso <paolo.mancuso@gesi.it> >Date: Mon, 10 Feb 1997 18:33:36 +0100 >X-Informix-List-Id: <list.13091> > >What should I do to know if an index is "asc" or "desc"? >Which table should I query? > >I have INFORMIX-OnLine Dynamic Server, Version 7.1 RTFM? The information is per-column in the index -- you can do CREATE INDEX i ON t(c1 asc, c2 desc, c3 asc); Descending order for a column is indicated by a negative (non-null) column number in the partX fields. This is covered in the Informix Guide To SQL: Reference manual, in the chapter on the system catalogue, table SysIndexes. For 7.1, the page reference is p2-26..p2-29. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>