Re: Tuning question

Why don't you set up a development database to run your test queries on? That way, you'll know for sure!

HTH,
Brian

sergey_s_at_my-deja.com wrote:
>
> How can I justify using hash join over sort-merge join in theory?
> I cannot really just run the tests to see which join performs better
> because the tables involved are a couple of billions rows and I cannot
> tie up the db like that.
>
> Thanks!
>
> Sergey
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================