RE: Table Joins

  • From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
  • To: <genegurevich@xxxxxxxxxxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 24 May 2006 16:54:27 -0500


Like Mark said, try it and find out. The side-effect of figuring out how
to test and measure a hypothesis like this is worth FAR more in the long
run than the value of the specific answer that you/they find out.

Why guess? ...when you can KNOW.

Cary Millsap
Hotsos Enterprises, Ltd.
Nullius in verba
Hotsos Symposium 2007 / March 4-8 / Dallas
Visit for curriculum and schedule details...

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Sent: Wednesday, May 24, 2006 4:01 PM
To: oracle-l
Subject: Table Joins

Hi all:

One of my developers insists that joins by numerical fields result in
better preformance than the joins by
character fields. I don't remember reading much on this point. Is there
truth in it?

thank you

Gene Gurevich



Other related posts: