I have a query that I could run a number of ways:
Like this:
index_word.word ~*'radio.*'
OR
index_word.word ~*'spry.*'
Or I could use LIKE and the "%" comparison
If I toss out the need for comparisions I could just use: IN
('radio','spry')
What's the relative performance for: "IN" "LIKE" or "~*"? I'm trying to
decide if the performance loss of doing extra string compares is worth
getting slighly more relevant results.
Matt Friedman