Is there way to build a compound index?

Posted in 2000

Mike Ratliff — Thu, 22 Jun 2000 15:08:06 -0500 — source: Informix-list mailing list archive (1991-1998)

I have a table with a road name field and an AKA(also known as) name field. Is there a way to get both names in a single index?. I can not think of a way to do it. The last programming language(ezc) allowed you to build any index key on a record that you wanted - about its only redeeming plus. Help if you can.