Avoid to use "IN", "NOT IN" in SQL statement, try to use "LEFT JOIN" instead.
摘要：
When ever you write any SQL statements, try to avoid use "IN", "NOT IN" keyword, even "EXISTS", "NOT EXISTS" Most of people think "EXISTS" is better than "IN", becuase it will use index, but the trut... 阅读全文