MySQL 视图是否比普通查询更快?

Is a MySQL view faster than a normal query?(MySQL 视图是否比普通查询更快?)

问题描述

我有一个使用许多连接(实际上是 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 视图是否比普通查询更快?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！