From: Zardosht Kasheff
Date: October 8 2009 2:33pm
Subject: Re: understanding handler::read_time and handler::scan_time
List-Archive: http://lists.mysql.com/internals/37364
Message-Id: <2f9663ba0910080733i2ac7e379n678a0be571033d6@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

handler::index_only_read_time() does not exist in 5.1.36.

My guess is that it depends on how the return value of scan_time
relates to get_index_only_read_time(), right?

-Zardosht

On Thu, Oct 8, 2009 at 5:06 AM, Sergei Golubchik <serg@stripped> wrote:
> Hi, Zardosht!
>
> On Oct 07, Zardosht Kasheff wrote:
>> Another question,
>>
>> are we guaranteed that the return value of scan_time will not cause
>> the optimizer to use a full table scan over a covering index over a
>> portion of the table?
>
> Looks like it depends on what you return in handler::index_only_read_time=
().
>
> Regards / Mit vielen Gr=FC=DFen,
> Sergei
>
> --
> =A0 __ =A0___ =A0 =A0 ___ ____ =A0__
> =A0/ =A0|/ =A0/_ __/ __/ __ \/ / =A0 Sergei Golubchik <serg@stripped>
> =A0/ /|_/ / // /\ \/ /_/ / /__ =A0Principal Software Engineer/Server Arch=
itect
> /_/ =A0/_/\_, /___/\___\_\___/ =A0Sun Microsystems GmbH, HRB M=FCnchen 16=
1028
> =A0 =A0 =A0 <___/ =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Sonnenallee 1, 85551=
 Kirchheim-Heimstetten
> Gesch=E4ftsf=FChrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
> Vorsitzender des Aufsichtsrates: Martin H=E4ring
>