Bigger tables vs. several smaller ones?

the question is too begginers' Miroslav Renda http://www.m7m.cz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

How MySQL proceses JOIN

are open in one time and the temp. table is created so that one row is composed from all the tables and then it proceeds to another? Thanx much Miroslav Renda - Before posting, please check: http://www.mysql.

DISTINCT problem

vious one. But I'm neither sure if this is possible in mySQL nor if this is faster then the DISTINCT. Thanx for any help. Miroslav Renda http://www.m7m.cz - Before posting, please check: http://www.mysql.com/manual.