Re: Subquery is real slow

[Bob Field]

Try something like this:

SELECT pw.id
FROM word AS w
JOIN paragraph_word AS pw ON pw.word_id = w.id
WHERE w.word_str IN ('mike', 'jen')