To find where a list of 100 words occurs in a dataset of 40,000 obs I ran a
cartesian join then sub-setted the results with if index(desc,word)>0
However, this obviously would be a bad idea on a large couple of datasets.
What is the more sophisticated way to do this, or would embedding the index
in the sql join have yielded a reasonable performance result?
Any comments much appreciated
create table c2 as
select codes.*, med.word
from codes, med;