Re: Building an Index on a Substring

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