Hi,
whats the difference between:
alter table tablename add index (name);
alter table tablename add index (age);
alter table tablename add index (birthdate);
alter table tablename add index (city);
compared to:
alter table tablename add index (name,age,birthdate,city);
What I want is performance/speed in doing the following:
select * from tablename where name = 'bill';
select * from tablename where age > 30;
select * from tablename where city = 'new york';
thanks
jaime
database,mysql
---------------------------------------------------------------------
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