>From the MySQL Manual (13.6 Other Optimization Tips)
http://www.mysql.com/doc/T/i/Tips.html
"Columns with identical information in different tables should be declared
identical and have identical names. Before Version 3.23 you got slow joins
otherwise. Try to keep the names simple (use name instead of customer_name in
the customer table). To make your names portable to other SQL servers you
should keep them shorter than 18 characters."
I'm a little confused about this statement. I'm reading two possible tips,
and I want to make sure I understand...
How does keeping names 'simple' optimize my database?
How does naming columns with identical information in different table the
same optimize my database?
Thanks,
Nathan
---------------------------------------------------------------------
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
