> Try creating a compound index on T2 which combines the State, City,
> Street and Address columns (in that specific order), this should help at
> least a little.

Seems that may be longer than an INDEX may accommodate. Can an index be used
to efficiently index a total length of so many characters?

I know for keys that you only get so many bytes...

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com