CODEWITHSUNDEEP
mysql
Uday
Uday

Reputation: 1490

EXPLAIN PLAN: what is the difference between "using where" and "using index" in MYSQL

What is the major difference between 'uing where' and 'using index' in EXPLAIN plan of MYSQL.

I think this is just the searching for the records from disc vs searching from memory respectively.

Thanks, -UDAY

Upvotes: 0

Views: 858

Answers (1)

Frédéric Hamidi
Frédéric Hamidi

Reputation: 263147

The documentation explains the difference:

  • Using index means the requested column data can be fetched from the index only, without having to read the row data proper.

  • Using where means the index is actually used for lookups, instead of only for fetching the requested column data.

Upvotes: 4

Related Questions