May binary fields consume more time than ordanary fields

cy163 · #1 (**permalink**) 12-04-08, 06:53

Hello ALL,
a table tb_A is created as

Code:

 create table tb_A (Word varchar(20) binary NOT NULL);

or created as

Code:

 create table tb_A (Word varchar(20) NOT NULL);

There is another table tb_B. It is created as

Code:

create table tb_B (Word varchar(20) binary  NOT NULL);

or as

Code:

create table tb_B (Word varchar(20) NOT NULL);

do the following query over tb_A and tb_B

Code:

SELECT
      Word
FROM
      tb_A, tb_B
WHERE
      tb_A.Word = tb_B.Word;

I wonder if the binary modifier would cause longer execution time?

Thanks

r937 · #2 (**permalink**) 12-04-08, 08:45

what happened when you tested it?

cy163 · #3 (**permalink**) 12-04-08, 09:07

I would like to add the 'binary' to the Word column defination. Before doing that, i would like to have your opinion, since I have to redefine and re-create the table, consuming a lot of time. Do you have experience on this before.
thanks.

r937 · #4 (**permalink**) 12-04-08, 09:30

nope, never done it

that's why i was asking you

cy163 · #5 (**permalink**) 12-05-08, 00:02

i have tested on my database contains 200,000 records. There are not noticeable changes in execution time.

r937 · #6 (**permalink**) 12-05-08, 00:23

thanks for the update

now i'll be ready in case anyone else asks that question

Internet Services

Web Development

Digital Marketing

Consumer Tech