Re: Is there way to build a compound index?

From: "Mike Ratliff" <mike_ratliff@iname.com> > >Perhaps I was not clear enough.I will try to be more lucid. >I need the road name as a key and the aka road name as a separate key >within >the same index or an equivelant way to perform this task.Setting the key as >(road name,aka road name) does not accomplish this. The search would >involve several thousand records, so temp tables and in memory sorts would >be too slow. Thanks for your time. >Ex. record 1 Road Name-Central Ave Aka Road Number-Farmer Street >I need to index keys for this record to be: >Central Ave >Farmer Street Now *I'm* lost. Have you lead me astray? :-) Firstly, this *is* a real database, and sorting "several thousand records" should take "a few seconds" at most. But from what I can see of your requirement, my suggestion will work or you can create separate indexes on both columns. Do you perhaps have the SQL you're trying to run? Are you perchance trying to say Select blah blah blah from whatever where road_name = "X" or aka_name = "X" Or what? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com