List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 22 2001 10:40pm
Subject:Re: Using identical column names in seperate tables
View as plain text  
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
	dnelson@stripped
Thread
Using identical column names in seperate tablesNathanial Hendler23 May
  • Re: Using identical column names in seperate tablesDan Nelson23 May