> Put the test-values into a temporary table, analyse it and then join > against it.
Ok, I didn't think of it.
> Can't say about indexes without knowing more about your > usage pattern.
What do you mean?