Join performance on different data types
Date: Tue, 13 Oct 2009 09:10:36 -0700 (PDT)
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