Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Query Analyzer / Tune up Selects

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Query Analyzer / Tune up Selects

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 24, 2004 at 8:46 pm #15503
      Shadow
      Member

      MySql provides the EXPLAIN statement for analyzing queries (only SELECT statements, though). It's quite impossible for a client to tell how MySql optimizes a query if no API is supplied… See the corresponding sections in the MySql manual (How MySql optimizes…).

    • February 25, 2004 at 8:53 am #15504
      Smeagle
      Member

      Hi,

      thanks for that info (explain) it's better than nothing 🙂

      I understand, a query analyzer would be very hard to do… But it's the feature I miss most, after switching vom MSSQL…

      I now noticed why I had problems in optimizing indicies: mySQL seems not to use a newly created index at the first few querys after generating it!? If I send the same query a couple of times after setting up index it gets faster and faster…. 🙁

      – Oliver

    • February 25, 2004 at 11:23 am #15505
      Shadow
      Member

      The speed gain must not be attributed to the indices, it is the result of the query cache. I noticed that sometimes MySql does disregard indices created for speeding up queries. Try using FORCE INDEX to make MySql take advantage of your work!

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.