Re: how does Oracle do field comparisons with good performance ?

From: Jack <jack_posemsky_at_yahoo.com>
Date: 14 Mar 2006 20:55:25 -0800
Message-ID: <1142398525.601071.252370@i39g2000cwa.googlegroups.com>

Jim Kennedy wrote:
> "Jack" <jack_posemsky_at_yahoo.com> wrote in message
> news:1142386479.437384.282530_at_i40g2000cwc.googlegroups.com...
> > Hi,
> >
> > Setting aside indexes, does anyone know how the technical Oracle
> > internals do row by row, field by field compares of data for a join
> > between 2 tables with decent performance ?
> >
> > Thanks,
> >
> > Jack
> >
> Have you read the documentation? There is a lot of well organized
> information in there. What is your business problem that you are trying to
> solve or understand?
> Jim

Yes but the documentation does not explain how the algorithms / low level code works under the hood to actually enable a join to occur..

Can you tell me how it works in detail ?

thanks,
jack Received on Tue Mar 14 2006 - 22:55:25 CST