List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:October 12 2011 8:05am
Subject:Re: Index question
View as plain text  
----- Original Message -----

> From: "Tompkins Neil" <neil.tompkins@stripped>

> Thanks for the information. One final question in what ways should we
> use EXPLAIN EXTENDED statement to help improve our query
> performance.

Explain is your friend. You should listen to it :-) 

It gives a nice idea of how the database interprets your query, so you can see where the
bottlenecks are, for example what bits don't use indices or cause file sorts. 

The exact interpretation of it is an art, though, and there are many subtleties you only
get by experience and reading documentation. It is not something that is quickly
explained; it requires a good knowledge of how a database works on the inside. 

-- 
Bier met grenadyn 
Is als mosterd by den wyn 
Sy die't drinkt, is eene kwezel 
Hy die't drinkt, is ras een ezel 

Thread
Index questionAlex Schaft11 Oct
  • Re: Index questionJohan De Meersman11 Oct
    • Re: Index questionNeil Tompkins11 Oct
      • Re: Index questionRik Wasmus11 Oct
        • Re: Index questionAlex Schaft11 Oct
          • Re: Index questionAlex Schaft11 Oct
          • Re: Index questionRik Wasmus11 Oct
            • Re: Index questionNeil Tompkins11 Oct
              • Re: Index questionRik Wasmus11 Oct
                • Re: Index questionJohan De Meersman11 Oct
                  • Re: Index questionTompkins Neil11 Oct
                    • Re: Index questionJohan De Meersman12 Oct
  • Re: Index questionArthur Fuller11 Oct