From: Zardosht Kasheff
Date: June 25 2009 6:18pm
Subject: feedback/review requested for fix to MySQL bug #45759
List-Archive: http://lists.mysql.com/internals/37006
Message-Id: <2f9663ba0906251118w55358910m2991da8711b88bf6@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hello,

I am interested to hear feedback on a patch I have submitted for a
feature request, bug #45759 (http://bugs.mysql.com/bug.php?id=45759).

This patch notifies the storage engine of when a full index scan is
about to take place (e.g. "select count(*) from foo use_index(a);").
By default (in handler.h), the storage engine does nothing. Individual
storage engines can choose to do whatever they want in this case to
make full index scans faster.

The purpose of this patch is to give storage engines an opportunity to
be aware of full index scans, and in turn, make optimizations should
they choose to.

Thanks
-Zardosht