Hi,
I have a table with 2 million records but without an index or a primary key.
The column upon which I want to create an index is a varchar. Will it give me
any advantage when I have to do a select on the column?
BTW, here is the scenario:
create table `test` (`phonenumber` varchar(100));
insert into test (phonenumber) values(`0001234567');
and so on 2 million times
alter table test add index (phonenumber)
Also, I can't modify the code that calls the SQL. It was written in VB and
the developer has left the company with the source.
I would like to get your feedback before I actually do this because I don't
want to create a disruption when the DB is in production.
Thanks
Murthy
---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
