New posts in Query Optimization

Speeding up inner joins between a large table and a small table

Optimize database schema / indexes for faster query result when using LIKE and EXISTS clauses

Meaning of "Select tables optimized away" in MySQL Explain plan

PostgreSQL LIKE query performance variations

Counting DISTINCT over multiple columns

How can I further optimize a derived table query which performs better than the JOINed equivalent?

How do I use DB2 Explain?

JOIN queries vs multiple queries

Does a SQLite Foreign key automatically have an index?

For autoincrement fields: MAX(ID) vs TOP 1 ID ORDER BY ID DESC