Oracle join on 2 int fields vs. char or float field

From: Date: Fri, 01 Dec 2000 04:09:15 +0000
Subject: Oracle join on 2 int fields vs. char or float field
Groups: php.db 
Request: Send a blank email to php-db+get-4914@lists.php.net to get a copy of this message
Does anyone know whether it is faster to left join on two integer fields or one text field or one float field? CHAR select t1.f1, t2.f1 ... from t1, t2 where t1.char_field_1 = t2.char_field_1(+) and .... The char field would be something like 12345-9876543 OR FLOAT select t1.f1, t2.f1 ... from t1, t2 where t1.float_field_1 = t2.float_field_1(+) and .... The float field would be something like 12345.9876543 OR 2 INTEGERS select t1.f1, t2.f1 ... from t1, t2 where t1.int_field_1 = t2.int_field_1(+) and t1.int_field_2 = t2.int_field_2(+) and .... The integer fields would be 12345 and 9876543 Thanks, Dan

« previous php.db (#4914) next »