Re: SMI query for Index column names

Posted in 1998

Art S. Kagel — Thu, 24 Sep 1998 12:36:33 -0400 — source: Informix-list mailing list archive (1991-1998)

Douglas Agnew wrote: > > the solution would appear to be a union across all the part1--part16 > where the value is not zero. [SNIP] > > Let me put in this way. If you use > > dbaccess->database->tables->indexes > > it shows you all the indexcolumn names for all the > > indexes. > > How can i get this from SMI query. Actually you are querying the database's system catalog tables not SMI, but I won't nit pick ;-) I just want to add that if any column is declared as descending in the index (less common in 7.3x since 7.3 can use ascending indexes for descending searches) the column number in the partxx will be negated so the filter should be: c.colno = abs(x.part1) etc. Art S. Kagel