Bug #30756 "using index condition" in EXPLAIN is not documented

• Submitted: 1 Sep 2007 14:28
• Modified: 21 Jun 2008 19:59
• Reporter: Baron Schwartz (Basic Quality Contributor)
• Status: Closed
• Category: Server: Docs
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: Paul DuBois
• Tags: qc
• Triage: D4 (Minor)

[1 Sep 2007 14: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 19: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