Wednesday, April 19, 2017

MySQL 8.0: Improved performance with CTE

Last week I published a blog post in the MySQL Server Blog where I showed how the execution time of a query was reduced by 50% by using a Common Table Expression (CTE) instead of a view.

In the coming weeks, there will be several opportunities to attend a presentation on CTE and another SQL feature that will arrive in MySQL 8.0, Window Functions.  This presentation is part of the Oracle MySQL Innovation Day that will be held both in the Bay Area (April 28) and in the Boston Area (May 2).

I will also give the presentation at the Boston MySQL Meetup on May 1st.

I hope to see some of you there!



  1. If you want your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (no matter why you broke up) you got to watch this video
    right away...

    (VIDEO) Want your ex CRAWLING back to you...?

  2. BlueHost is definitely the best hosting provider with plans for any hosting needs.