内部表是在初始化ids时创建的。
利用内部表的索引恰好是一个聚集索引。
The index exploited for the inner table happens to be a clustered index.
一共有7 种内部表。
文档类型定义(DTD)注册并存储在内部表中。
Document type definitions (DTDs) registered and stored in internal tables.
OP_CLOSE操作更新这个内部表,但没有被发送到服务器。
The OP_CLOSE operation updates that internal table, but is not sent to the server.
基数越高,进入内部表、每一条合格的(外部)记录的探测就越多。
The higher the cardinality, the more probes into the inner table, one per qualifying (outer) record.
共享内存头包含共享内存中所有其他结构的描述,包括内部表和缓冲池。
The shared-memory header contains a description of all other structures in Shared memory, including internal tables and the buffer pool.
它选择一个散列连接,以PART作为内部表,这个计划只需运行299秒。
It selects a hash join with PART as the inner table which runs in 299 seconds.
对于从数据库选择大量数据的情况,这可以是一个内部表,这有助于提高性能。
This can be an internal table for bulk selects from the database, which has performance advantages.
然而,合并扫描联接的好处是不必反复地扫描内部表因为其为嵌套循环联接工作。
However, the benefit of the merge scan join is that the inner table does not have to be scanned repeatedly as it does for nested loop joins.
为了便于讲解,使用ABAP write语句把这个内部表的内容输出到标准输出设备。
For the purpose of illustration the contents of this internal table are printed to the standard output device using an ABAP write statement.
这个命令在模板定义中自动包括了所有用户定义表,并排除了数据库中定义的视图和内部表。
This command automatically includes all the user-defined tables in the template definition and excludes the views and internal tables defined in the database.
一条内部表的记录将与来自外部表的每条合格的记录相匹配(内部输入基数值是1)。
One record of the inner table will match each qualifying record from the outer table (inner Input Cardinality value is 1).
尽管使用字符串变量更容易,但是如果通过远程函数调用发送动态sql,可能需要使用内部表。
Although using a string variable is easier, you might need to use an internal table if a remote function call sends the dynamic SQL code.
因此,在决定选择哪种联接方法时,优化器为内部表扫描平衡排序成本和性能优势以便促进决策。
Therefore, when deciding which join method to choose, the optimizer balances the sort cost and the performance benefit for the inner table scan to drive the decision.
也就是说,联接操作的内部表将被扫描8次,来自外部输入的 8 个合格的记录每个都将被扫描一次。
That is, the inner table of the join operation will be scanned eight times, once for each of the eight qualifying records from the outer input.
那些内部表的目的和功能是为了记录共享内存资源的状态和使用,例如缓冲区、块、dbspace、事务等。
The purpose and function of those internal tables is to keep track of shared-memory resources status and usage such as buffers, chunks, dbspaces, transactions and so on.
通常情况下,在外部输入的基数显然不小且对于内部表没有一种有效的访问方法时,优化器会选择合并扫描联接。
Typically, the optimizer chooses merge scan join when the cardinality of the outer input is not obviously small and there is no efficient access method for the inner table.
因为通过TBSCAN扫描内部表,即不能对MSJOIN保证预期的顺序,所以添加sort节点来执行顺序。
Because the inner table is scanned with TBSCAN, which does not guarantee the expected order for MSJOIN, a SORT node is added to enforce the order.
操作系统通过一个内部表将处理器地址空间中的内存段映射到内存页,该表定义哪些内存段由哪些处理器所拥有,等等。
Operating systems map memory segments in a processes' address space to memory pages through an internal table which defines what memory segments are owned by what processes, and so on.
从性能的角度来看,这被认为是一个非常有效的联接操作,因为通过贯穿唯一索引的唯一访问扫描内部表的成本是最优的。
From the performance perspective, this is considered a very efficient join operation, because the cost for scanning the inner table is optimal via unique access through a unique index.
在数据库服务器使用所有表筛选器之后,从外部表检索出的行数将很少,而内部表具有一个可用于执行连接的索引。
The number of rows retrieved from the outer table after the database server applies any table filters is small, and the inner table has an index that can be used to perform the join.
如果连接列上有一个索引,那么其成本会相当低;否则,数据库服务器就必须对所有表(外部和内部表)执行表扫描。
If there is an index on the join column, the costs will be significantly less; otherwise the database server must perform table scans for all tables, both outer and inner tables.
一般来说,如果内部索引是良好的集群且预测内部表被多次探测,则使用复合排序的嵌套循环联将受到优化器的青睐。
In general, a nested loop join with sort composite is favored by the optimizer if the inner index is well-clustered and the inner table is expected to be probed many times.
如果内部表没有索引,那么数据库服务器就会将在表上构建索引的成本与连续扫描的成本进行比较,然后选择成本最低的那一种方法。
If the inner table does not have an index, the database server will compare the cost of building an index on the table to the cost of a sequential scan, and will choose the one with the least cost.
OpenSQLselect子句总是需要一个数据结构,比如结构或内部表(对于大量调用),它要把调用的结果放在这个数据结构中。
An Open SQL select clause always needs a data structure where it can put the results of the call, such as a structure or an internal table for bulk calls.
尽管XML在内部存储为层次化格式,但逻辑上,在数据库表中,它似乎存储在CLOB或BLOB中。
Although internally the XML is stored in a hierarchical format, logically in the database table it appears to be stored in a CLOB or BLOB.
如何在注册表内部和外部定义和管理服务元数据?
How is service metadata defined and managed within and outside of the registry?
注意:策略值将存储在表内部。
外部和内部样式表都可以缩小。
You can use minification for both external and internal style sheets.
应用推荐