3 million rows

[willwein]

Hi,

I have a table with two colums:
id = numeric - auto_increment
prod_id = numbers and letters:
12139E39
3239A332
etc...
there are 3 million rows..
i am new to mysql/databases..
when i do:
select from table where id=something..
the query takes 0.0 seconds
however,
select from table where prod_id = something
takes 14 seconds..
the type for prod_id i entered as text because it had letters in it too..
how can i get 0.0 seconds for prod_id search too?
pick a different value type.. char..?
use index..?

[ultraslacker]

Yes, use index.

Not indexing means that the dbms has to perform a sequential scan, which can get expensive.