I'm pretty sure you can load a query result into an [1] in memory table and query that including generated indexes. [1] https://dev.mysql.com/doc/refman/8.0/en

I'm pretty sure you can load a query result into an [1] in memory table and query that including generated indexes. [1] https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engin...