MySQL视图比普通查询快吗? [英] Is a MySQL view faster than a normal query?

问题描述

我有一个使用许多联接的复杂查询(实际上是8个).我当时正在考虑将其简化为一个视图.经过一些研究，我可以看到简单性和安全性的好处.但是我没有提到速度.

I have a complex query using many joins (8 in fact). I was thinking of simplifying it into a view. After a little research I can see the benefits in simplicity and security. But I didn't see any mentions of speed.

视图是否像预编译的语句那样工作，查询是在预编译的地方进行的?使用视图是否可以显着提高性能?

Do views work like prepared statements, where the query is pre-compiled? Is there any notable performance gain from using views?

推荐答案

不，视图只是存储的文本查询.您可以对其应用WHERE和ORDER，将在考虑了这些子句的情况下计算执行计划.

No, a view is simply a stored text query. You can apply WHERE and ORDER against it, the execution plan will be calculated with those clauses taken into consideration.

这篇关于MySQL视图比普通查询快吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！