在此文件内,应用程序连接到数据库并针对此目录表运行查询。
It's where the application connects to the database and runs the query against the directory table.
在命令行中对下列三个表运行RUNSTATS,如下所示
Run RUNSTATS on the following three tables from a command line, as follows
可用这一选项来只删除分析数据库中与运行相关的表。
You can use this option to remove only the tables associated with the run in the analysis database.
这说明您没有运行创建数据库表的SQL文件。
What this indicates is that you forgot to run the SQL file that creates the database tables.
这与在运行ALTERFRAGMENT 后的表上执行完整的统计刷新是不同的。
This is not equivalent to running a complete statistics refresh on resulting tables of an ALTER FRAGMENT.
假设有一个针对非常大的表运行的查询,它使用同一个缓冲池并且需要读取比总的缓存区大小还多的页。
You might also have a query that runs against a very large table that USES the same buffer pool and involves reading more pages than the total buffer size.
该特性省去了DBA运行INSPECT或者手动重组所有表的麻烦。
This feature removes the need for the DBA to run INSPECT or to reorganize all tables manually.
客户数据库只有一个表,可以通过运行清单6中的脚本创建。
The customer database has a single table that can be created by running the script shown in Listing 6.
当在会话中设置STATCHANGE后,它将影响该会话中在其上运行updatestatistics的表。
When STATCHANGE is set in a session, it affects the tables on which update statistics is run in that session.
它选择一个散列连接,以PART作为内部表,这个计划只需运行299秒。
It selects a hash join with PART as the inner table which runs in 299 seconds.
当旧有运行的输出表细节信息不需保留,而需要保留规则的历史记录时,应当使用这一选项来节省分析数据库的空间。
You should use this option to save space on the analysis database when the details of the output table of older runs are no longer needed, while keeping the run history of the rule.
在应用程序会话定义已创建的临时表之后,并发运行的会话不需要重新定义它。
After an application session defines a created temporary table, concurrently running sessions do not have to redefine it.
在 ADMIN_MOVE_TABLE过程运行时,TPCD.PART表是完全可访问的并且分区键的更改对于终端用户是透明的。
While the ADMIN_MOVE_TABLE procedure is running, the TPCD.PART table is fully accessible and the change to the partitioning key is transparent to the end users.
图6显示了运行数据库创建脚本后的事件存储表。
Figure 6 shows the event store table after running the database creation scripts.
由于没有自动运行UPDATESTATISTICS,所以systemcatalog表没有更新,仍然保留旧的统计数据。
Since the update STATISTICS are not run automatically, the System Catalog tables would not be updated and would still be retaining the old statistical data.
如果要使对过滤表的更改生效,需要在运行此命令时带上一些参数。
For the changes done to the filters table to take effect, you'll have to run this command with some arguments.
为确保优化器选择的查询计划能够最好地反映表的当前状态,应定期运行UPDATESTATISTICS。
To ensure that the optimizer selects a query plan that best reflects the current state of your tables, run UPDATE STATISTICS at regular intervals.
由于碎片整理操作可能运行得很快,特别对于小表更是如此,所以只能在很短的时间内看到碎片整理信息。
Since the defragment operation may run quickly, especially for smaller tables, the defragment information may be available for only a short period of time.
最佳实践:为节省分析数据库的空间,应当从旧有运行中删除不需要的输出表。
Best practice: To save space in the analysis database, you should delete the output tables from older runs when they are no longer needed.
请注意:与其他选项不同,在运行InfoSphereDataStage作业时,不会删除ccd表内容。
Note: Unlike the other options, this does not delete the contents of the CCD table as part of running the InfoSphere DataStage job.
在目标表所在的服务器上,运行merge语句,如清单14所示。
On the server with the target table, run the merge statements, as shown in Listing 14.
创建了EXPLAIN表之后,就可以用 EXPLAIN模式运行下面的查询
Once the EXPLAIN tables are created, you are ready to run the following query in EXPLAIN mode
第二个表给出了使用Mail7模板运行Domino7模拟用户的结果。
The second table shows results with simulated Domino 7 users running the Mail7 template.
无法访问数据库表中所有链接的字段。运行“数据库向导”并重新链接形状以更正此问题。
Cannot access all of the linked fields in the database table. Run the database Wizard and re-link the shape to correct the problem.
无法从数据库表中传输所有链接字段的数据。运行“数据库向导”并重新链接形状以更正此问题。
Cannot transfer all of the data for the linked fields from the database table. Run the database Wizard and re-link the shape to correct the problem.
数据库触发器是驻留在数据库中的程序,当数据库中的表发生更新之类的事件时会运行该触发器。
A database trigger is program residing in the database that runs when an event, such as an update, occurs on a table in the database.
运行rakedb:migrate以创建SUBSCRIPTIONS表并将外键列添加到SUBJECTS 中。
Run rake db:migrate to create the SUBSCRIPTIONS table and add foreign key columns to SUBJECTS.
现在,运行自己创建的一些代码,并查看SQL创建表的过程。
Now run some of the code you created and see the SQL to create a table.
NWindReader帐户使用db_datareader角色(将其访问限制为读取数据库中的表)运行。
The NWindReader account runs under the db_datareader role, which limits its access to the reading of tables in the database.
NWindReader帐户使用db_datareader角色(将其访问限制为读取数据库中的表)运行。
The NWindReader account runs under the db_datareader role, which limits its access to the reading of tables in the database.
应用推荐