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

Gene,

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.
http://www.hotsos.com
Nullius in verba
 
Hotsos Symposium 2007 / March 4-8 / Dallas
Visit www.hotsos.com for curriculum and schedule details...


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
genegurevich@xxxxxxxxxxxxxxxxxxxxx
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
any
truth in it?

thank you

Gene Gurevich


--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: