Hash Join

From: <eshevtsov_at_my-deja.com>
Date: 2000/07/23
Message-ID: <8lfik1$auj$1@nnrp1.deja.com>#1/1

Hello.

I have 2 questions about hash join.

First. Does the server process (on behalf of my user process) copy table or index blocks of source to the db cache while as it's building the
hash table from this source in the hash_area memory?

Second. In which case the cardinality of result set of rows after hash join could be higher than the highest cardinality of its sources? Is it possible for equiajoin?

Thanks in advance.

Edward

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jul 23 2000 - 00:00:00 CDT