Trying to speed up MySQL queries. I must admit that when it comes to indexing tables that are joined alltogether and use foreign keys almost everywhere that’s one hell of a task, since foreign key index always wins due to index merges and intersects.
