I have a seven column table and need to match values contained in these columns with values in lookup tables. Probably using "LIKE" for the SELECT.
The lookup tables have one, two and three part terms. These are in the second column and primary ids are in the first.
I'm wondering the best way to go about this. Whether it is with a series of these lookup tables which could be run on a nightly basis.
With this I'm looking at full table scans. Not ideal but I'm not for sure how else this may be done. Any ideas?
