Re: Tuning question

From: <sergey_s_at_my-deja.com>
Date: 2000/07/26
Message-ID: <8llakm$grt$1@nnrp1.deja.com>#1/1

I am sure I could test with the subsets of the tables, but I think the performance would be a whole different story with the real size tables I think.

Sergey

In article <uu2ddhncc.fsf_at_yahoo.com>,
Galen Boyer <galenboyer_at_yahoo.com> wrote:
> >>>>> "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
>
>

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