From: Richard Auslander <rich@airflash.com>
>
>Environment: IDS 7.30UC5, Solaris 2.6
>
>I'd like to build a very compact and efficient index on the first "n"
>characters of a varchar column. The table has 12 million records in it,
>and I don't need very precise or exact searching - although I do need
>high performance. Is there a way to accomplish this? I know I could
>add a new column to this table that just contains those "n" characters,
>but that seems like a hack. The informix "create index" command, of
>course, won't permit me to use substring syntax, i.e., "create index foo
>on bar(name[1,5]);". Does anyone know of other good-quality options?
>Many thanks ...
If you went to 9.2 (IDS.2000), you could create a function to do the
substring and build an index on the function. You shouldn't have any hassles
going from 7.30 to 9.20.
HTH.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com