We will, however, update statistics for them.
然而,我们将会为其更新统计数据。
Version 1: To UPDATE STATISTICS for the entire database.
版本1:用于整个数据库的UPDATE statistics。
You cannot run UPDATE STATISTICS against an external table.
不能针对一个外部表运行update STATISTICS。
Run the command UPDATE STATISTICS HIGH against the database.
对数据库运行命令update STATISTICS HIGH。
For the rest of the table, the update statistics command is NO-OP.
对于其他的表,不会执行update statistics命令。
Run the update statistics command to create or refresh statistics.
运行update statistics命令,创建或者更新统计。
List: Provides the actual "Execution Command" to run update statistics.
List:提供用来运行统计数据更新的命令。
This example shows why UPDATE STATISTICS has to be run periodically.
这个例子表明为什么必须定期运行UPDATE STATISTICS。
Version 2: To UPDATE STATISTICS for a particular table in a database.
版本2:用于数据库中特定表的UPDATE STATISTICS。
Version 5: To perform UPDATE STATISTICS by setting your own resolution.
版本5:通过设置自己的分辨率执行update STATISTICS。
What is the ideal mode that I should use for the Update Statistics command?
用于Update Statistics命令的理想模式是什么?
For example, you could run the update statistics command daily instead of weekly.
例如,可以每天而不是每周运行update statistics命令。
The number of rows in a table, as of the most recent UPDATE STATISTICS statement.
从最新的UPDATE statistics语句起,表中的行数。
Had you executed the UPDATE STATISTICS statement, it would have been much more efficient.
但是,如果执行了UPDATE STATISTICS语句,那么效率就会高得多。
Consider a typical scenario where the importance of UPDATE STATISTICS can be demonstrated.
考虑一个典型的场景,这个场景可以演示UPDATE STATISTICS的重要性。
Right click on the GOSALES.PRODUCT table and select Update statistics as shown in Figure 22.
右键单击GOSALES . product表,选择update statistics,如图22所示。
Prior to IBM Informix V11.7, when you ran the update statistics command, statistics were always recreated.
在IBMInformixV11.7 之前,当运行update statistics命令时,统计数据总是会重新创建。
The nickname statistics update facility, which allows you to update nickname statistics.
昵称统计信息更新功能,它允许更新昵称统计信息。
In this case, the "Last statistics update" column is empty.
在这个例子中,“Laststatistics update”列是空白的。
Allows an application to update device statistics.
允许应用程序更新设备统计信息。
Allows an application to update device statistics.
允许应用程序更新设备统计信息。
应用推荐