Efficient range query

#21

On 2010-11-26 21:47, Axel Schwenke wrote:

Quote:

Hi Lennart,

Lennart Jonsson <erik.lennart.jonsson (AT) gmail (DOT) com> wrote:

Axel, you don't happen to have a link or two to articles or reference
material that discusses explain and related stuff in mysql?

All the gory details are in The Funtastic Manual [1] of course.
Google also finds a "MySQL Explain Cheatsheet". I seem to remember
there was some tool that reads EXPLAIN output and brings it to a
more readable form. Was that

http://www.maatkit.org/doc/mk-visual-explain.html ?

Thanx Axel. Maatkit looks promising. At a first glance

http://www.maatkit.org/doc/mk-index-usage.html

looks good to. The cheatsheet will also come in handy.

/Lennart

[...]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Efficient range query

comp.databases.mysql comp.databases.mysql

Re: Efficient range query - 11-26-2010 , 05:37 PM