MySQL 4.1 for Windows performance problems

http://lists.mysql.com/mysql/202489

Excellent explanation.

SQL: The value of NOT NULL

Most SQL resources teach only the language. It's hard to find blogs with useful advice, and even harder to find bloggers who back up their claims. Here is an excellent article:

"The NOT IN took over 5 times longer to execute and did thousands of times more reads."

That site has lots of interesting comparisons for various SQL queries.

---

Here are some other useful links:

• Indexing
• SQL Myths