I am looking at my slow query logs and trying to fix some of slow queries, I identified one to fix and ran EXPLAIN on it and noticed it using filesort