sql – mysql fix Using where;

sql – mysql fix Using where;

The only thing that would be better than Using where is Using where; Using index with a covering index. Try selecting just uid and created_date.

Using where is fine. It means its applying the indicated index to the WHERE clause and reducing the rows returned. To get rid of it, youd have to get rid of the WHERE clause.

Here are things that you should be concerned about:

  • Using filesort
  • Using temporary
  • Not using an index: NULL in the key column of the EXPLAIN and a large number of rows in the rows column.

Your EXPLAIN result shows that MySQL is applying index1 to the WHERE clause and returning 2 rows:

1 SIMPLE updates_cats ref index1 index1 8 const 2 100.00 Using where

sql – mysql fix Using where;

Leave a Reply

Your email address will not be published.