Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Performance aka. Table Joins

Re: Performance aka. Table Joins

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 25 May 2006 09:18:59 -0700
Message-ID: <bf46380605250918hbdb4aa3i4d5f242af50e493d@mail.gmail.com>


Excellent!

Thank you Wolfgang, for taking the time to build a test case and sharing it.

Jared

On 5/25/06, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
> Several posters have made excellent comments about the use of number
> datatypes
> vs. character datatypes for columns that are, or may be, involved in
> joins.
> First off I want to say that join performance should be (one of) the last
> considerations in determining the datatype of a column. The datatype
> should
> first and foremost be appropriate for storing the intended content.
>
> In the other posts the predominant gist was
> a) test it
> b) numbers ought to have an edge as far as performance is concerned
>
> Now let me give you this testcase:
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 25 2006 - 11:18:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US