Optimize wp_options table

Hi,

I was looking through some MySQL logs on my server, checking for slow queries and non-indexed queries. There seem to be a lot of queries like this:
SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’

Autoload is not indexed, shouldn’t it be ?

The column type is set to var, wouldn’t be more efficient to be enum(‘yes’,’no’) ?

Will Macdonald