这种高效支持您更新一个不可更新的视图。
这些可更新的视图允许更新某些统计信息,从而研究假想数据库的性能,或者更新统计信息而不使用RUNSTATS实用程序。
These updatable views allow you to update certain statistical information to investigate the performance of a hypothetical database, or to update statistics without using the RUNSTATS utility.
关于如何使用可更新编目视图来优化性能的讨论超出了本文的范围。
A more detailed discussion of how to use the updatable catalog views to optimize performance is beyond the scope of this article.
实际上,您可以使用SQLupdate语句来更改可更新编目视图中的统计列。
In fact, you can use SQL UPDATE statements to change the values of statistical columns in updatable catalog views.
其中一组只读视图在SYSCAT模式下创建,另一组更小的可更新视图则是在SYSSTAT 模式下创建的。
One set of read-only views is created under the SYSCAT schema, and a smaller set of updatable views is created under the SYSSTAT schema.
SYSSTAT模式包含少量的基于系统编目表的可更新视图。
The SYSSTAT schema contains a small number of updatable views that are based on the system catalog tables.
SYSSTAT:一组可更新的编目视图。
本文在多关系FD理论的基础上讨论了三个问题。1。一致的和可更新的关系视图的恰当定义。
Based on the multiple relation FD theory, this paper discusses the three topics: 1. Proper definitions of the consistent and updatable relational views.
查询和视图设计器无法事先确定您是否可更新基于视图的结果集。
The Query and View Designer cannot determine in advance whether you can update a result set based on a view.
查询和视图设计器无法事先确定您是否可更新基于视图的结果集。
The Query and View Designer cannot determine in advance whether you can update a result set based on a view.
应用推荐