Simple Query Optimization by Indexing

[jomsfx]

I have a really simple query but can't figure out how to make it faster. It's just something like:

 

SELECT field1 FROM table1 WHERE field2 = 'value'; 

 

Because of 300,000 rows in the table it takes around 50 seconds to execute.

I have been researching about indexes and tried to create an index for field2(varchar 80) with an Index Type of Normal and Index Method of BTREE, but the process is still slow.

The storage engine is InnoDB.

 

Once I solve this I will be adding other criteria in the WHERE clause using other columns within the said table.

 

If you could suggest another way to speed this up or could point me to the right direction I would really appreciate it.

 

Thanks.

 

[fenway]

Show us the EXPLAIN output.

[jomsfx]

id:1

Select Type: Simple

table: table1

type: ref

possible keys: field2

key: field2

key len: 43

ref: const

rows: 40950

Extra: Using Where

 

This is how I created the index:

 

CREATE INDEX field2 ON table1(field2(40));

 

Thanks

 

[fenway]

That's not EXPLAIN output -- I mean post mysql's query plan using EXPLAIN.