Re: Is there way to build a compound index?

From: "Mike Ratliff" <mike_ratliff@iname.com> > >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. Wow. That's amazing. Unless you consider: CREATE INDEX foo ON mytable (road_name, aka_name); ? Looks like a visit to my favourite porn site is in order, too: http://www.informix.com/answers ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com