Re: Is there way to build a compound index?

you have a table like? create table mytable ( road_name varchar(20), aka_name varchar(20)..... ); create index idx_names_01 on mytable ( road_name, aka_name);or 'create unique index...' Mike Ratliff wrote: > 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.