RE: Table Joins

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Wed, 24 May 2006 16:54:27 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF54E655@WIN02.hotsos.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discoverfinancial.com
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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 24 2006 - 16:54:27 CDT