Join performance on different data types

From: Pratap <pratap.deshmukh_at_gmail.com>
Date: Tue, 13 Oct 2009 09:10:36 -0700 (PDT)
Message-ID: <82860056-a238-4492-b1ff-574c3f83509a_at_f16g2000yqm.googlegroups.com>

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. Received on Tue Oct 13 2009 - 11:10:36 CDT

This message: [ Message body ]
Next message: Mladen Gogala: "Re: Suitability of Oracle for storing/maintaining medical records?"
Previous message: Mark D Powell: "Re: 8i "until change is before resetlogs" error"
Next in thread: John Hurley: "Re: Join performance on different data types"
Reply: John Hurley: "Re: Join performance on different data types"
Reply: Mark D Powell: "Re: Join performance on different data types"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message