Re: Join performance on different data types

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Tue, 13 Oct 2009 11:13:08 -0700 (PDT)
Message-ID: <c7d97043-1416-47a8-ac6d-eb2f883a53d7_at_m11g2000yqf.googlegroups.com>

On Oct 13, 12:10 pm, Pratap <pratap.deshm..._at_gmail.com> wrote:

snip

> Hi,
>
> Database is Oracle 10.2.0.4.0
> I have two identical test tables, each with a varchar2 and number
> column (vsize of both is 3). When I join the table on varchar2, the
> performance is very slightly lower than the join on the number column.
> Theorotically, in Oracle is there any reason why join on number will
> be faster than a join on varchar2 column?
>
> Thanks.

Why don't you post you complete test case so we can see exactly what you are doing.

Wild shot guess in the dark is implicit conversion is getting invoked. Received on Tue Oct 13 2009 - 13:13:08 CDT