Why does this query takes a lot of time

[abhishek jain]

Dear Friends,
I have two table joined by the followng query, the problem is this simple
query takes a lot of time greater than 10 mins depending on the number of
records, Pl. help me find out the reason:
Table 1:
id_key primary and auto increment
recordID varchar(100)
login_name varchar(255)
blah
blah


Table 2:
id_key primary and auto increment
recordID varchar(100)
blah
blah


Query:
SELECT count(  *  ) FROM table1 s, table2 c WHERE s.login_name =  'abhishek'
and s.recordID=c.recordID;

recordID in table 1 needs to be same to that in table2.I mean recordID needs
to be the mapping thing.

Pl. help me it is important to me.
Thanks,
Abhishek Jain