About EXPLAIN: Extra column information

2014-05-29 Thread Alfonso Maestro Lira
Can anybody explain me the difference between using index, using index condition and using where in the EXTRA column information of EXPLAIN query? I have read the official doc but i am confused. Thank you.

Re: About EXPLAIN: Extra column information

2014-05-29 Thread Claudio Nanni
Hi, Can anybody explain me the difference between using index, using index condition and using where in the EXTRA column information of EXPLAIN query? using index: the columns selected are part of an index that is used to return the results, there is no need then to read the full table record