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? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster