MySQL Forums
Forum List  »  MyISAM

Re: One table vs. multiple tables? (SELECT/WHERE effeciency)
Posted by: Ingo Strüwing
Date: July 19, 2006 01:53AM

IMHO #2 is faster as you have one condition only and I don't see two tables used. If there were two tables, it would be less efficient.

ENUMs are stored like TINYINT or SMALLINT and hence as efficient. See:
http://dev.mysql.com/doc/refman/5.0/en/enum.html
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

Regards
Ingo

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: One table vs. multiple tables? (SELECT/WHERE effeciency)
1736
July 19, 2006 01:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.