[Stylock]

One of the best MySQL tuts around, but I think it's missing a few essential things:

• relationship types
• foreign key indexing
• clustered index

I've been taught that every table should have a clustered index, especially when foreign keys are involved. A useful quote:

Quote:

Originally Posted by Brad McGehee As a rule of thumb, every table should have a clustered index. Generally, but not always, the clustered index should be on a column that monotonically increases–such as an identity column, or some other column where the value is increasing–and is unique. In many cases, the primary key is the ideal column for a clustered index. http://www.sql-server-performance.co...tered-indexes/

Also, If anyone's interested, there's a visual database design tool called MySQL Workbench, which is perfect for designing relational databases.