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, date date not null, comment varchar(255) not null index (date), index (comment) ); Ok I indexed the VARCHAR but I'll never use that key in a where statement. E.G: SELECT comment from comments group by date; I only indexed it in the hope mysql won't do a disk seek because the comment is allready in memory since it is a key. After looking in the mysql doc "How mysql handles indexes". I'm not sure if mysql will do it the way I expect it to. Thanks in advance Best regards, Patric de Waha --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php