Tempspace1 - Stores system temporary tables.
Tempspace1——存储系统临时表。
RUNSTATS on declared global temporary tables.
已声明的全局临时表上的runstats。
Extended indexes or declared temporary tables.
扩展的索引或声明的临时表。
Use temporary tables and table variables appropriately.
适当的使用临时表和表变量。
Temporary - to store the system temporary tables created during database processing.
Temporary——存储数据库处理过程中所创建的系统临时表。
You should create one or more USER temporary table spaces for storing data of temporary tables.
您应当创建一个或多个USER临时表空间来存储临时表的数据。
User temporary table spaces: User temporary table spaces store declared global temporary tables.
用户临时表空间： 用户临时表空间存储已声明的全局临时表。
You can even use temporary tables from the DB2 Command Line Processor (CLP), as you will soon see.
下面很快就能看到，您甚至可以通过DB 2命令行处理器(CLP)使用临时表。
This section discusses the behaviors of created temporary tables that should be taken into account.
本节讨论应该考虑的已创建的临时表的行为。
At least one user temporary table space should be created to allow the definition of declared temporary tables.
至少应当创建一个用户临时表空间以允许定义已声明的临时表。
Created global temporary tables (CGTTs) are a new feature in DB2 9.7 that provide the following new capabilities.
已创建的全局临时表(CGTT)是DB 2 9.7中的新特性，它提供了以下功能。
These statistics are stored in memory structures that represent the catalog information for declared temporary tables.
这些统计信息存储在表示声明的临时表的目录信息的内存结构中。
In Step 4, we doubled SORTHEAP to 2048 to avoid sort overflows because some queries needed to create temporary tables.
在步骤4中，我们使SORTHEAP加倍到2048以避免排序溢出，因为某些查询需要创建临时表。
Temporary dbspaces: : a temporary dbspace is a regular dbspace, used by the database server to store temporary tables.
临时dbspace：临时dbspace属于常规dbspace，数据库服务器在存储临时表时将使用到它。
Table Spaces that you create in DSNDB07 will be used as storage for processing SQL joins and sorts as well as for temporary tables.
您在DSNDB07创建的表空间将用作处理SQL联接和排序以及临时表的存储。
Under certain conditions, internal temporary tables are created during the execution of the merge statement, as shown in Listing 7.
在某些条件下，会在merge语句执行过程中创建内部临时表，如清单7所示。
SQL Azure is based on the relational database model, complete with constraints, transactions, temporary tables, and stored procedures.
SQLAzure的基础是关系数据库模型、提供了对约束、事务、临时表以及存储过程的完整支持。
A general extension to global temporary tables, which allows temporary tables that are not logged to be completely taken out of transaction control.
对全局临时表的一个通用扩展，允许没有日志记录的临时表完全脱离事务控制。
One implication of this behavior is that a session can manipulate its temporary tables even if the current user has no privilege to create them.
这种行为的一个影响是，即使当前用户没有创建它们的权限，会话也可以操纵它的临时表。
There are no differences in the declarations of local variables, cursors, temporary tables, but on both platforms the order of declaration is important.
在局部变量、游标和临时表的声明方面，两种平台没什么差别，但在这两种平台上，声明的顺序却很重要。
A user temporary tablespace, for declared temporary tables, can be created in IBMDEFAULTGROUP or any user-created database partition group, but not in IBMTEMPGROUP.
用于已声明的临时表的用户临时表空间可以在IBMDEFAULTGROUP或任何用户创建的数据库分区组中创建，但不能在IBMTEMPGROUP中创建。
According to demands of the system function, main database table (Standard database), total procedure table, contract table and other temporary tables were established.
依据系统功能实现要求，建立了主数据库表(标准库)、工序总表、台帐表和多种过渡表。
Recall that in order to use temporary tables, a user temporary table space must exist in the database (none exists by default). Here's how you would create such a table space.
我们记得为了要使用临时表，数据库中必须存在一个用户临时表空间(默认情况下没有)。
To keep privileges for temporary and nontemporary tables separate, a common workaround for this situation is to create a database dedicated to the use of temporary tables.
为了保持临时表和非临时表的权限分开，这种情况的常见解决方法是创建专用于临时表的数据库。
In DB2 9.5, automatic dictionary creation was added so you no longer had to deal with building a dictionary yourself; in DB2 9.7, indexes and temporary tables can now be compressed.
在DB 2 9.5中，添加了自动字典创建，所以不再需要自行构建字典；在DB 2 9.7中，索引和临时表现在可以压缩。
These enhancements will be of particular interest to organizations with large business intelligence (BI) applications and data warehouses, which depend on indexes and temporary tables.
这些改进对于使用大型业务智能化(BI)应用程序和数据仓库的组织尤其有意义，因为它们依赖于索引和临时表。
New support for including XML columns in declared global temporary tables deserves brief mention, because it can help programmers to improve the runtime performance of their applications.
这里有必要提到现在支持在声明的全局临时表中包含xml列，因为这可以帮助程序员提高应用程序的运行时性能。
CREATE TEMPORARY TABLES, LOCK TABLES.
创建临时表，锁表。
Temporary tables are stored in user temporary table Spaces.
临时表存储在用户临时表空间中。
Temporary tables must be declared before they can be referenced. The following SQL procedure (created from the command line) demonstrates the process.
临时表在进行引用之前必须先声明。
应用推荐