Re: Is an index on varchar column efficient?

Baron Schwartz <[EMAIL PROTECTED]> wrote: murthy gandikota wrote: > 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? >

Re: Is an index on varchar column efficient?

mos <[EMAIL PROTECTED]> wrote: At 06:23 PM 4/15/2007, you wrote: >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? > > B

Re: Is an index on varchar column efficient?

At 06:23 PM 4/15/2007, you wrote: 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 ta

Re: Is an index on varchar column efficient?

murthy gandikota wrote: 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

Is an index on varchar column efficient?

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` va