关于视图的一件奇怪的事情是，它们被Microsoft Access视为表:当您使用ODBC将Microsoft Access前端附加到SQL数据库时，您将在可用表列表中看到表和视图。因此，如果你在MS Access中准备复杂的报告，你可以让SQL服务器来做连接和查询，这大大简化了你的工作。在Excel中准备查询也是如此。

在对遗留数据库进行报告时，视图可能是天赐之物。特别是，您可以使用有意义的表名，而不是神秘的字母名(其中两个字母是常见的前缀!)，或者充满缩写的列名，我确信这在当时是有意义的。

当我只运行查询时，我喜欢在存储过程上使用视图。视图还可以简化安全性，可用于简化对多个表的插入/更新，并可用于快照/物化数据(运行长时间运行的查询，并保持结果缓存)。

我使用物化视图来执行不需要实时保持准确的查询。

当我想要查看一个表的快照和/或视图(以只读方式)时

视图是查询的封装。转换为视图的查询往往比较复杂，因此将它们保存为视图以供重用是有好处的。

我通常创建视图来反规范化和/或聚合经常用于报告目的的数据。

EDIT

By way of elaboration, if I were to have a database in which some of the entities were person, company, role, owner type, order, order detail, address and phone, where the person table stored both employees and contacts and the address and phone tables stored phone numbers for both persons and companies, and the development team were tasked with generating reports (or making reporting data accessible to non-developers) such as sales by employee, or sales by customer, or sales by region, sales by month, customers by state, etc I would create a set of views that de-normalized the relationships between the database entities so that a more integrated view (no pun intended) of the real world entities was available. Some of the benefits could include:

减少编写查询时的冗余 建立关联实体的标准 提供机会 评估和最大化绩效 用于复杂的计算和连接 (例如在Schemabound视图上建立索引 在该软件中) 让数据更容易获取 对于团队成员和非开发人员来说是直观的。