Join performance on different data types

From: Pratap <>
Date: Tue, 13 Oct 2009 09:10:36 -0700 (PDT)
Message-ID: <>


Database is Oracle
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

Original text of this message