In the last episode (May 21), Nathanial Hendler said:
> >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...
They put two ideas into that paragraph:
1 - Identical definitions on joined fields make the optimizer happy
2 - For neatness purposes, use simple column names
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
