improve mysql select query speed

Question

I am using mysql 14.14 in my django application.

One of my tables has 300,000+ records having 30 columns.

On page load i have to list all the date field values.

So I queried with 'Select date from table'. But it takes about 35 seconds to load the page.

How can I improve the speed of the query ?

I am working in Ubuntu 12.04 i3 processor 4GB RAM 320GB hardisk.

Answer 1

Indexes should be enough to optimize your query. Have a look at this docs here and here