Refresh table: In some data warehouses, the entire table is dropped once per year and a replacement table is loaded with all the data except for the data that is no longer needed.
刷新表:在某些数据仓库中,整个表每年删除一次,然后装载一个替代的表,这个新表包含了除不再需要的数据以外的所有数据。
The size of the table (number of entries per page) and data refresh rates can also be changed to meet the your needs.
还可以修改表的大小(每个页面上的条目数量)和数据刷新频率以满足自己的需要。
But it does demonstrate that it's easy to put together a table that sorts quickly, without a page refresh and without bothering the server to do the hard, uninteresting work of the sort.
但是它确实说明了创建一个能够快速排序的表非常简单,并且无需刷新页面,也不需要服务器来执行麻烦无聊的排序工作。
If the table has fragment-level statistics, the decision to refresh statistics is done at the fragment level, thereby rebuilding statistics only for changed or new fragments.
如果表具有片段级统计,那么将在片段的层面上判断是否执行统计刷新,因此只有片段被修改或出现新片段的情况下重建统计。
Another query against the summary table returns no data, but after the REFRESH table statement executes this time, the query runs successfully.
再次查询总结表,又是没有返回数据,但是当执行了REFRESH table语句之后,查询得以成功运行。
To do this, use the Browse button (which is labeled only with ellipses, or three dots) in each row of the Value column in the unresolved path map symbol table, and then click Refresh.
要这样做,就使用未辨别的路径图符号表中的Value列的每一行中的Browse按钮(标记为省略号,或三个点),然后单击 Refresh。
The idea is to use the staging table to incrementally refresh the MQT, rather than regenerate the MQT from scratch.
其思想是,使用staging表增量式地刷新MQT,而不是从头开始重新生成MQT。
The MQT refresh is triggered when the table tab2 involved in its definition is populated.
当为MQT定义中涉及的表tab2填充数据时,就会触发对MQT的刷新。
The system verification status automatically refreshes, but you can manually refresh it by clicking the Refresh link in the upper right corner of the verification status table.
系统验证状态会自动刷新,您也可以单击验证状态表右上角的Refresh链接手动刷新它。
The fact that Ajax lets you interact with a server without a full refresh puts the option of a stateful client back on the table.
Ajax让我们不需要进行完全刷新就可以与服务器进行交互,这一事实使有状态客户机再次成为可用选择。
If dependents such as staging tables or refresh immediate MQTs exist on the partitioned table, the second phase starts automatically after these dependents are refreshed via SET INTEGRITY.
如果在已分区表上存在类似临时表或者立即刷新MQTs之类的依赖表,第二阶段会在利用SETINTEGRITY刷新了这些依赖表后自动启动。
Refresh (Snapshot) replicates a snapshot of the source table to the target table.
Refresh (Snapshot) 把源表的快照复制到目标表。
If a guideline is updated, or deleted from the table, then it is necessary to refresh the cache by issuing the FLUSH OPTIMIZATION PROFILE cache statement, so it can be used.
如果从这个表中更新或删除一个指南,那么需要通过发出FLUSHOPTIMIZATIONPROFILEcache语句更新缓存,使之可以被使用。
Use the same process to refresh the current row counts for the GOSALES.PRODUCT_FORECAST table (right click on the table, select Update statistics, click in the SQL Results window).
通过同样的过程刷新GOSALES . PRODUCT _ forecast表的当前行数(右键单击该表,选择updatestatistics,在SQLResults窗口中单击鼠标)。
Taking it a step further, you could even add the sorting links into the table headers manually and have them refresh the page, passing variables to re-sort the table accordingly.
再考虑远些,甚至还可以给表格头部手动添加一些排序链接,通过传递排序表格的相应参数,让它们能刷新页面。
A query against this MQT right after it was created, but before the REFRESH TABLE statement was issued, returns an error.
当这个mqt刚创建且还没有发出REFRESH table语句的时候,对它的查询将返回一个错误。
The cache table facility in the Control Center, which lets you set up local caches of nicknames using replication as the refresh mechanism.
ControlCenter中的缓存表功能,它使您可以使用复制作为刷新机制来建立昵称的本地缓存。
If your table contains relational and XML data and you want to refresh the relational statistics only, you can execute RUNSTATS with the new clause "EXCLUDING XML COLUMNS".
如果表包含关系数据和XML 数据,而您又只想刷新关系数据的统计信息,那么可以带新的子句 “EXCLUDING XMLCOLUMNS”来执行RUNSTATS。
The staging table is pruned when the refresh operation is complete.
当刷新操作完成时,staging表就会被删除。
DEFERRED means that the data in the table can be refreshed at any time using the refresh table statement.
DEFERRED的意思是,表中的数据可以在任何时候通过REFRESH table语句来刷新。
So, if the MQT is created with such a statement, the REFRESH TABLE statement will fail.
所以,如果MQT是用那样的语句创建的,那么REFRESH table语句将失败。
The 'refresh table' command is not supported on user-maintained MQTs.
refresh table'命令在用户维护的MQT上不受支持。
The refresh DEFERRED clause means that the data in the table can be refreshed at any time using the refresh table statement.
REFRESHdeferred子句的意思是,在任何时候都可以用REFRESH table语句刷新该表中的数据。
In the case of refresh-deferred MQTs, make sure that the special register CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION is set to a value that includes the category of your MQT.
对于刷新延迟的MQT,确保特殊注册表CURRENTMAINTAINED TABLETYPESFOROPTIMIZATION被设置为一个包含您的MQT种类的值。
After the REFRESH TABLE statement executes, the query runs successfully.
而执行了REFRESH table语句之后,对它的查询可以成功运行。
The REFRESH TABLE statement returns a warning, a reminder that the "integrity of non-incremental data remains unverified."
REFRESH table语句返回一条警告,提示说“integrityof non - incrementaldata remains unverified ”。
The REFRESH TABLE statement (used for system-maintained MQTs) cannot be issued against user-maintained MQTs.
不能对用户维护的MQT发出REFRESH table语句(用于系统维护的MQT)。
If the MQT is a system-maintained MQT, it can be populated with data using a 'REFRESH TABLE' statement. The "REFRESH TABLE statement can be invoked for our example MQT as."
如果MQT是系统维护的MQT,那么可以使用'REFRESH TABLE '语句用数据填充它。
It can refresh the router table by the previous delay information to find a suitable path with the constraints of the bandwidth and the delay-jitter.
该算法直接利用前一周期的时延信息来更新路由表,以作为当前寻找路径的依据,在满足带宽和时延波动约束条件下,使数据传送过程时延最小化。
It can refresh the router table by the previous delay information to find a suitable path with the constraints of the bandwidth and the delay-jitter.
该算法直接利用前一周期的时延信息来更新路由表,以作为当前寻找路径的依据,在满足带宽和时延波动约束条件下,使数据传送过程时延最小化。
应用推荐