Bug #30756 "using index condition" in EXPLAIN is not documented
Submitted: 1 Sep 2007 12:28 Modified: 21 Jun 2008 17:59
Reporter: Baron Schwartz (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Paul DuBois CPU Architecture:Any
Tags: qc

[1 Sep 2007 12:28] Baron Schwartz
Description:
The new "using index condition" optimization (index condition pushdown) isn't documented in EXPLAIN.  I was able to find it mentioned on page 32 and 33 of Timour's slides from the user's conference this year (http://conferences.oreillynet.com/presentations/mysql07/katchaounov_timour.pdf)

How to repeat:
See bug #30659 for an example.

Suggested fix:
I'm not sure this optimization is even in any currently released and documented version.  Apologies if it's not documented just because it's too soon :)
[21 Jun 2008 17:59] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

See:
http://dev.mysql.com/doc/refman/6.0/en/using-explain.html
http://dev.mysql.com/doc/refman/6.0/en/index-condition-pushdown-optimization.html