MySQL Lists: internals: Re: understanding handler::read_time and handler::scan

List:	Internals	« Previous Message Next Message »
From:	Michael Widenius	Date:	October 8 2009 9:01am
Subject:	Re: understanding handler::read_time and handler::scan_time
View as plain text

Hi!

>>>>> "Zardosht" == Zardosht Kasheff <zardosht@stripped> writes:

Zardosht> Another question,
Zardosht> are we guaranteed that the return value of scan_time will not cause
Zardosht> the optimizer to use a full table scan over a covering index over a
Zardosht> portion of the table?

It can do that, if the scan time is very low.

Regards,
Monty

Thread
• understanding handler::read_time and handler::scan_time	Zardosht Kasheff	7 Oct
• Re: understanding handler::read_time and handler::scan_time	Sergei Golubchik	7 Oct
• Re: understanding handler::read_time and handler::scan_time	Zardosht Kasheff	7 Oct
• Re: understanding handler::read_time and handler::scan_time	Zardosht Kasheff	8 Oct
• Re: understanding handler::read_time and handler::scan_time	Michael Widenius	8 Oct
• Re: understanding handler::read_time and handler::scan_time	Sergei Golubchik	8 Oct
• Re: understanding handler::read_time and handler::scan_time	Zardosht Kasheff	8 Oct
• Re: understanding handler::read_time and handler::scan_time	Sergei Golubchik	8 Oct
• Re: understanding handler::read_time and handler::scan_time	Sergei Golubchik	8 Oct
• Re: understanding handler::read_time and handler::scan_time	Michael Widenius	8 Oct