Thomas Hamilton <thomashamilton76(at)yahoo(dot)com> writes:
> But in our testingunder the same optimization and conditions INNER JOIN is significantly outperforming IN.
[ shrug... ] You haven't provided any details, so it's impossible to
offer any useful advice.
regards, tom lane