You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Amir Michail <am...@gmail.com> on 2008/11/04 00:18:43 UTC

hash vs table scan

Hi,

What is the difference between a hash and table scan?

Amir

-- 
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail

Re: hash vs table scan

Posted by Rick Hillegas <Ri...@Sun.COM>.

Amir Michail wrote:
> Hi,
>
> What is the difference between a hash and table scan?
>
> Amir
>
>   
Hi Amir,

There's a good explanation of the hashing strategy in the "Join 
strategies" section of the Derby Tuning Guide: 
http://db.apache.org/derby/docs/10.4/tuning/

Hope this helps,
-Rick