Whenever possible, create all indexes on a table before initially loading it, since the load utility builds indexes more efficiently than the create index process.
只要有可能,应该在初次装载一个表之前创建其所有索引,因为LOAD实用程序建立索引的效率比CREATEINDEX过程要高。
When dealing with large amounts of data, the initial loading of the data into the table can present some performance challenges.
当处理大量的数据时,一开始将数据装载到表中时可能会遇到性能问题。
While doing an UNLOAD, you can also generate corresponding LOAD control statement and use it for loading data to the same or a similar table in any DB2 subsystem.
在执行UNLOAD 时,您还可以生成相应的LOAD控制语句,并使用它加载数据到任何DB2子系统中的相同或类似的表中。
TDEE supports loading data into a table only.
TDEE只支持将数据加载到表中。
Problem loading the descriptor table, most likely due to a corrupt descriptor table.
加载描述符表时出现问题,最常见的原因是描述符表错误。
Loading namespaces declaration is similar to loading columns from a table definition — it loads namespaces from the XML table definition.
名称空间声明的装载类似于从表定义中装载列——从xml表定义中装载名称空间。
It depends on the type and a few other properties of the target table while performing the loading operation.
执行加载操作时,这取决于目标表的类型和其他几个属性。
DELUXE mode provides more concurrency to the target table while loading, whereas EXPRESS mode expects the target table to be a RAW table.
DELUXE在加载时向目标表提供更多并发性,而EXPRESS模式期望目标表是一个raw表。
It USES the FastLoad utility and provides the function of loading bulk data into an empty database table.
它使用FastLoad实用工具并提供了将批量数据加载到空数据库表中的功能。
While loading, if the target base table is fragmented, the load happens in parallel under the PDQ environment.
加载时,如果目标基表被碎片化(fragmented),加载过程将在PD Q环境下并行发生。
In another example, the it Operational Manager has been notified that an ETL job for loading the fact table has been aborted when reading its input in the processing stage DB2_Input_Facts.
再举一个例子:IT运营经理接到通知,一个装载事实表的ETL作业在处理准备阶段DB 2 _ Input_Facts中读取输入时失败了。
Within the migration, you can populate the database table, perhaps by invoking a SQL script or loading a fixture.
在迁移中,可以填充数据库表,可能通过调用SQL脚本或装载fixture。
The following IBM technote talks about a possible problem that may be encountered with RUNSTATS when loading a table.
下列IBM 技术札记(technote)谈到了加载一个表时运行RUNSTATS可能碰到的问题。
For automatic loading of the target table by the Q Apply program, federated Q replication supports only the EXPORT and IMPORT utilities.
为了通过QApply程序自动装入目标表,联邦q复制仅仅支持EXPORT和IMPORT实用程序。
sample 2 is the reverse process of the former XML publishing sample, loading XML documents to the customer table and the contact table.
示例2是前面XML发布示例的反向过程,它将 XML文档装载到客户表和联系方式表中。
The file that will be used for loading the data into the table contains the following data.
该文件用于将数据加载到表中,包含下列数据。
After loading the XML table definition "target_xml," the XML output stage is shown as illustrated Figure 18.
装载xml表定义“target _ xml”之后,xml输出stage如图18所示。
Create the contents of the free_chunks result table by loading the free_chunks.unl file.
通过装载free_chunks . unl文件,创建free_chunks结果表的内容。
This requires that the data from the transactional system be transformed before being loading into the warehouse table.
这需要在将来自事务系统的数据加载到数据仓库表中之前,对其进行转换。
PCTFREE indicates to DB2 what percentage of each page in the table space or index to leave free when either loading or reorganizing the data.
PCTFREE 告诉DB2在装载或重组数据时,表空间或索引中的每个页要留出多少百分比的空余空间。
While loading, it is possible to reorganize the data to better suit the algorithms -- for example, loading into a hash table or a database may help in working with a large data set.
加载的时候,可以重新组织数据,以便更好地适应算法。比如,加载到散列表或者数据库中可以帮助处理大型数据集。
For a plate of vegetables to be placed on the dining table, it has to go through numerous processes, including testing, approval, loading, wholesale and distribution.
一盘蔬菜能端上餐桌,它必须要经历很多环节,包括检验,核准,装卸,批发,配送。
Initially they wanted to show most table columns. The application took as much as 30 minutes due to loading up to 1 million rows to the front UI, even though the DB responded within about 1 minute.
最开始他们想要显示大多数字段,尽管数据库能在1分钟内做出响应,应用程序也要花30分钟将1百万行数据加载到前端ui。
If you're using MySQL and want to define foreign keys for a table, you'll need to define those fields in code after loading the schema from the database.
如果使用的是MySQL,而且想要为表定义外键,则需要在从数据库中加载模式之后,编写代码定义这些字段。
Generatedoverride no no yes Specifies that generated column values in the load input file are to be used when loading data into a table that has a generated ALWAYS column.
generatedoverride no noyes指定在将数据载入一个带有generated always列的表中时,要使用载入输入文件中生成列的值。
Initially, these tasks will be limited: setting the table, loading a dishwasher, cleaning POTS, sweeping the floor, washing Windows or painting fences.
起初,这些任务种类将是有限的:摆桌子、将碟子放入洗碗机,拖地,清洗窗户,或涂栅栏。
Loading a XAML document occurs in a series of phases, as shown in the following table.
有一系列的阶段会载入XAML文件,如下表的说明。
The general loading arithmetic of Gauss heat source in ANSYS welding simulation is loading heat flux(HF)on the whole welding surface based on TABLE array parameters.
A NSYS焊接仿真中高斯热源的一般加载算法是:基于表参数的整面热流密度加载。
Elastic deformation is an important influential factor of indexing accuracy and loading capacity of end-tooth indexing table with drum tooth.
齿廓弹性变形是影响鼓形齿端齿盘精度和承载能力的重要因素。
These facilitate the working table loading and unloading process; especially indicated for heavy and big panels.
这些设备便利了一个工作台装载和卸载过程,尤其对重的和大型的木板。
应用推荐