A table will perform better (faster) if all of its text columns are of type CHAR rather than type VARCHAR (and there are no TEXT or BLOB columns to turn them all into VARCHARs behind your back). But do you still get a performance advantage when you join that table with another one that may have VARCHAR columns?
Thanks. Amittai Aviram [EMAIL PROTECTED] sql.query --------------------------------------------------------------------- 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
