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
