RE: Is there way to build a compound index?

>===== Original Message From "Obnoxio The Clown" <obnoxio@hotmail.com> ===== >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 I think he wants to be able to look up "foo" and get all entries which have "foo" in there road_name or aka_name. The only way I know of to do what he wants is to create two indexes and put and look for aka_name="foo" or road_name="foo". Hope this helps, Will ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------