[Sinner]

Quote:

Originally Posted by YJIET 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: Also, If anyone's interested, there's a visual database design tool called MySQL Workbench, which is perfect for designing relational databases.

I'm pretty sure indexed are added automatically by most database systems. I'm entirely sure for MySQL and Postgresql. You make a fair point, they do make a huge difference.

@OP

You should tell something about the good practices when creating queries. Things people should avoid (like using IN, SET operators, explicit joins, LIMIT, etc...) + why you should avoid subqueries (they are always slower) and things people should definately use or atleast attempt to use (like JOINs and GROUP BY). If a query is properly built up it can be executed 100x faster.

My course material explained it really well, unfortunately it's in dutch. I found this though: http://docs.oracle.com/cd/B10501_01/...1016.htm#28529