Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Tuning question
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.
Received on Tue Jul 25 2000 - 00:00:00 CDT