Comments on: MySQL indexing 101: a challenging single-table query https://www.percona.com/blog/mysql-indexing-101-a-challenging-single-table-query/ Fri, 12 May 2023 17:03:47 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Stephane Combaudon https://www.percona.com/blog/mysql-indexing-101-a-challenging-single-table-query/#comment-10837319 Thu, 04 Jun 2015 08:28:05 +0000 https://www.percona.com/blog/?p=29832#comment-10837319 Roland,

I no longer have the dataset to run EXPLAIN, but the execution plan will be very similar to the execution plan of Q2 shown at the beginning of the post.

]]> By: Roland Bouman https://www.percona.com/blog/mysql-indexing-101-a-challenging-single-table-query/#comment-10828973 Fri, 29 May 2015 11:41:52 +0000 https://www.percona.com/blog/?p=29832#comment-10828973 Excellent post, very insightful!

For completeness, it would be very instructive to show the EXPLAIN after adding the new index.

]]>