lec <[EMAIL PROTECTED]> writes: > Under 7.0.2, there are no Hash Join or Hash So, then, what *does* it do? Without the explain for 7.0.2 it's impossible to tell what's happening. > Are there any way to optimize this type of query? Um, have you vacuum analyzed the tables involved? regards, tom lane