System News
MySQL 8.0: Improved performance with CTE
By MySQL Server Team
April 12, 2017,
Volume 230, Issue 2

Oystein Grovlen blogs, "MySQL 8.0 introduces Common Table Expressions (CTE). My colleague Guilhem has written several blog posts on how to use CTEs , and you can also read about it in the MySQL 8.0 Reference Manual. In this blog post, I will focus on how using a CTE instead of a view or a derived table can improve performance.

As usual, my example query will be a query from the DBT-3 benchmark. This time, we will look at Query 15, the Top Supplier Query:..."

Read More ... [...read more...]

Keywords:

 

Other articles in the MySQL section of Volume 230, Issue 2:

See all archived articles in the MySQL section.

Trending in
Vol 230, Issue 3
Trending IT Articles