LATERAL Derived Tables in MySQL 8.0

Wednesday 5:10 PM - 5:35 PM

@ Texas 7


25 minutes conference



Since version 8.0.14, MySQL supports LATERAL derived tables, sometimes called the for each loop of SQL. What are they? How do they work? Why do you need them? What can they do? How can you use them? Should you use them? What is all this talk about for each loops?

In this session we'll explain the concepts, look at examples of how and when to use this new feature, and talk about how LATERAL derived tables are optimized and executed by MySQL.


Norvald Ryeng

Norvald Ryeng (Oracle)

Software Development Senior Manager


Norvald has been at Oracle since 2011 and is the MySQL optimizer
team lead, responsible for query optimization and execution. He holds a
PhD in Computer and Information Science from the Norwegian University of
Science and Technology.


  Download Slides  


Please sign in for 15 day access

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@)
  • +1-888-401-3401
  • +1-919-948-2863