Create an index on the ACCOUNT table as follows.
在account表上创建索引,如下。
Select the ACCOUNT table from the list of available tables for this schema.
从这个模式的可用表列表中选择account表。
To evaluate the new access plan after the index creation on the ACCOUNT table issue.
为了在account表上创建索引之后评估新的访问计划,要发出。
Consider a banking application where there is a very large account table for one of the dimensions.
考虑一个银行应用程序,其中针对一个维度有一个极其大型的帐户表。
Since the interest rate is an attribute of Account table, the Account dimension table needs to be added.
因为利率是account表的一个属性,所以需要添加account维度表。
The table annotation shown in Listing 4 is required to point to my renamed (lowercased) account table.
清单4中所示的Table注释需要指向我重命名的(小写的)account表。
In the example we are using, a relationship can be created between the regional Account table from one database to the Sales table in the other database.
在我们的示例中,我们将在一个数据库中的地区性account表和另一个数据库中的sales表之间创建一个关系。
The code here makes an ODBC connection to the MySQL database using MySQLi extension APIs and fetches all the account information stored in the account table.
这里的代码使用MySQLi扩展API建立到MySQL数据库的OD BC连接,并获取帐户表中存储的所有帐户信息。
The earlier access plan shows that the total cost of the SELECT statement is 3420.41 timerons, which is from the table scan operator (TBSCAN) against the ACCOUNT table.
前面的访问计划显示select语句的总成本是3420.41timerons,这来自于表扫描操作符(TBSCAN)对ACCOUN t表进行的操作。
The important principle may influence the grave degree about the judgement and decision-making the wrong report or the leaking report of the user of the account table.
重要性是指在特定环境下,可能影响会计报表使用者判断或决策的错报或漏报的严重程度。
Imagine you are transferring money from one account to another. Each account balance is represented by a row in a database table.
假设您正在从一个账户向另一个账户进行转账个账户差额由数据库表中的某一行来表示。
The T077D table has many columns besides the key columns holding the configuration data for each account group.
T077D表除了保持每个账户组的配置数据的关键列以外还有许多的列。
In a subsequent data flow operation, you'll use a join operator to ensure that full XML account records (contained in the INFO column) are fed into the target data warehouse table.
在随后的数据流操作中,您将使用一个连接操作符确保整个XML账户记录(包含在info列中)被填充到目标数据仓库表中。
With the table now populated with data and a means to access it, retrieve the amount overdue from account 12345.
现在表中已经填充了数据,并且可以使用某种方式访问它,那么现在从帐户12345中检索过期时间量。
It also populates the operational table with sample XML account information.
它还用示例XML账户信息填充操作型表。
Note that the customer credit card table has the privacy icon for the primary account number.
注意,客户信用卡表对主账户编号拥有隐私图标。
The example scenario extracts the data of the T077D check table, which holds all the valid values for the KTOKD (customer account group) field in the KNA1 table (customer master table).
示例场景提取了T077D检查表的数据,即在KNA1表(客户主表)上保持所有KTOKD(客户账户组)字段的有效值。
First of all, if the XML documents in your table contain namespaces, then the index definition will need to take that into account.
首先,如果表的XML文档包含了名称空间,则索引定义必须考虑名称空间。
For example, with deforestation taken into account, Indonesia and Brazil soar up the table to become the world's third- and fourth-largest emitters.
举例来说,如果把毁林这一因素考虑在内,印度尼西亚和巴西就会跃升到温室气体排放国的前列,分别位列世界第三和第四。
The DB2 set up script that you ran (either in step 1 or when following the steps in the first article of this series) created a target table for account portfolio information in your DB2 database.
DB 2设置要运行的脚本(在步骤1中或者按本系列第一篇文章中的步骤操作时),并为DB 2数据库中的帐户组合信息创建目标表。
A password change for the service account or the retiring of one application (and therefore, its service account) will not affect the other application (see Table 3).
服务帐户的密码更改或一个应用程序的退役(以及由此引起的服务帐户退役)将不会对另一个应用程序造成影响(表3)。
And I was at one end of the table, and the salesman for the account, and his whole staff, and he's at the other end of the table.
我在桌子的一头,旁边是销售人员,会计,然后是他的员工,他在桌子的另一头。
This same technique might be used to execute a DROP TABLE statement or to execute a system stored procedure that created a new user account and added that user to the sysadmin role.
这一技术可能会被用来执行DROPtable语句,或执行创建新用户帐户并将该用户添加到sysadmin角色的系统存储过程。
The USERS table contains the user account information that consists of the DB2 authid (authentication identifier), password, password expiry date, account status, and the number of failed logins.
users表包含用户帐户信息,包括DB 2authid(身份验证标识符)、密码、密码过期日期、帐户状态和失败的登录次数。
The DB2 server instance is owned by db2inst1 account, and the database DIRDB01 table schema is dirusr1.
DB2服务器实例为db2inst1帐户所有,且数据库DIRDB01表模式是dirusr1。
The account ID from this mapping operation can then be joined with the account ID included in the output of the Group By operation, creating a result set that will populate the target ACCT table.
然后,将该映射操作获得的账户ID与GroupBy操作的输出中包括的账户ID进行连接,创建一个结果集,该结果集将填充目标acct表。
As mentioned earlier, this table contains several relational columns for specific information about financial accounts as well as one pureXML column with full account data in XML format.
如前所述,这个表包含几个存储财务帐户的特定信息的关系列,以及一个以xml格式存储完整帐户数据的purexml列。
We'll replicate the employees table of the "db1" database in an update-anywhere fashion between server1 and server2. (The following steps assume the informix account is used.)
我们将使用 update-anywhere 方式在服务器 1和服务器 2之间复制 “db1”数据库的employees表(以下步骤假设使用了informix帐户)。
Create a table called accounts. This fictional table mocks a storage table of account Numbers.
创建名为accounts的表。
Create a table called accounts. This fictional table mocks a storage table of account Numbers.
创建名为accounts的表。
应用推荐