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)
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• 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