HELP :) Optimizing data file axs through adding indexes

Hi, I've a table which is read very often.. Simplified table structure: create table comments ( id int unsigned not null auto_increment primary key, datedate not null, comment varchar(255) not null

HELP :) Optimizing data file axs through adding indexes

Hi, I've a table which is read very often.. Simplified table structure: create table comments ( id int unsigned not null auto_increment primary key, datedate not null, comment varchar(255) not null