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

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 15 Mar 2006 09:19:14 -0800
Message-ID: <1142443153.991330.74930@u72g2000cwu.googlegroups.com>

Jack wrote:
> 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 ?

It looks like Mark gave you a decent url to look at.

Guy Harrison published a ( now somewhat dated book ) called "Oracle SQL High Performance Tuning" that you may find useful.

There are some good examples and explanations of how a nested loop works, a hash join, etc.

Once you digest that information you may want to look at a new book just out from Jonathan Lewis called "Cost-Based Oracle Fundamentals".

Neither of these is exactly light reading but they are well worth it for someone willing to put in some time and effort. Received on Wed Mar 15 2006 - 11:19:14 CST