Is there a way to cache a View so that queries against it are quick? July 20, 2023 by Tarik What you want to do is materialize your view. Have a look at http://www.fromdual.com/mysql-materialized-views.