Re: Tuning question

>>>>> "sergey" == sergey s <sergey_s_at_my-deja.com> writes:

 sergey> How can I justify using hash join over sort-merge join
 sergey> in theory?  I cannot really just run the tests to see
 sergey> which join performs better because the tables involved
 sergey> are a couple of billions rows and I cannot tie up the db
 sergey> like that.

Can you take a smaller subset of the tables, load that somewhere else and try?

-- 
Galen Boyer
Database Architect
Primix Solutions, www.primix.com