为几个列生成具有给定值分布的数据。
Generate data with given distribution of values for several columns.
我们可以使用该函数为代理键列生成惟一值。
It can be used to generate unique values for the surrogate key column.
如果要为具有唯一约束的列生成数据，则很可能会失败。
If you are generating data for columns that have unique constraints, it will likely fail.
所以，应该只为那些需要分布统计信息的列生成分布统计信息。
So restrict generating distribution statistics to those columns that require distribution statistics.
对于每条insert语句，DB 2将负责为其中的这一列生成一个惟一的值。
DB2 will be responsible for generating a unique value for the column for each INSERT statement.
排除列的能力：生成数据时，您可以排除某些列，从而脚本将不会为这些列生成数据。
Ability to exclude columns: While generating data, you can exclude columns and the script will adhere by not generating data for them.
服务器为表中的各个列生成数据分布，这些数据分布被以编码直方图的形式存储在sysdistrib系统编目的encdat列中。
Data distributions are generated by the server for individual columns of a table, and are stored as encoded histograms in the encdat column of the sysdistrib system catalog.
其中一列包含所生成的，唯一标识每个记录的关键字。
One of its columns contains a generated key that uniquely identifies each record.
如果查询谓词中引用的列存在显著的数据值倾斜，那么要确保DB 2了解这一情况，最好是使用RUNSTATS生成列值柱状图统计数据。
If a significant data value skew exists for a column referenced in a query predicate, make sure that DB2 knows this, preferably by generating column-value histogram statistics using RUNSTATS.
本例中的完整性是指与生成列规范的一致性。
Integrity in this case means consistency with the generated column specification.
尽量减少表上的触发器、检查和外键约束以及生成的列。
Minimize the triggers, CHECK and foreign key constraints, and generated columns for the table.
而一旦生成了关于“TYPE”列的分布统计信息，优化器即可了解每种型号真正的出现频率。
When distribution statistics are generated for the column "TYPE," the optimizer knows the real frequency of each model.
以不区分大小写的方式搜索DB 2数据有多种方法，比如使用生成的列(请参见参考资料)。
There are several methods to search DB2 data in a case-insensitive manner such as the use of generated columns (see Resources).
所生成的表有三列，列出所发现的各种服务的名称、摘要和位置。
The generated table has three columns, listing the names, abstracts, and locations of various discovered services.
在其最一般的形式中，UNNEST可采用几个阵列作为参数，且其可生成其他列以便反映子索引实施的顺序。
In its most general form, UNNEST can take several arrays as arguments, and it can produce an additional column to reflect the order imposed by the sub-indexes.
该连接的执行过程包括扫描散列连接中的内表CUSTOMERS，并通过散列连接列的值生成一个查找表。
The join is performed by scanning the inner table of the hash join, CUSTOMERS, and generating a lookup table by hashing the join column values.
接着将会生成一个三列的数据表。
视图改变表中的列顺序，以便这些列与生成的EJB持久性代码所期望的顺序相对应。
The views shuffle around the column order of the tables so that the columns correspond to the order expected by the generated EJB persistence code.
连接器将根据目标表和列定义在运行时生成查询s QL。
The connector generates the query SQL at runtime based on the target table and the column definitions.
指导者可以使用如图13 所示的表名和列定义生成SQL。
The connector can generate the SQL using the table name and column definitions as shown in Figure 13.
我偶尔需要从数据库生成两列或三列的输出。
I have occasionally needed to produce two-column or three-column output from a database.
必须在每次部署EJB时生成该脚本，否则列顺序可能会出错。
The script must be regenerated every time an EJB is redeployed, or the columns might end up in the wrong order.
指定生成的GROUPBY子句中包括的列，如图13所示。
Specify the columns to be included in the generated GROUP BY clause, as shown in Figure 13.
单元格的内容是由XML中行和列数据相交生成的。
The content of cells is created by intersecting items from the XML's data sets for rows and columns. Only cells that have data are part of the XML.
生成具有相关列的数据。
我们还添加了一个——sha1标志，它能根据实际Ruby源代码的SHA1散列值命名生成的。class文件。
We also added a — sha1 flag, which produces.class files named based on the sha1 hash of the actual Ruby source.
XMLTable可以从xml列中的数据生成标量输出，可以为程序员提供XML数据的“关系”视图，因此非常有用。
XMLTable generates tabular output from data stored in XML columns and is quite useful for providing programmers with a "relational" view of XML data.
也就是说，只要给定任何质询字符串，都可以合理地提出以下要求：“给我一个后缀，一旦challenge+suffix被散列，它将生成b比特的碰撞”。
That is, given any challenge string, it is sensible to ask, "Show me a suffix that will produce b bits of collision once challenge+suffix is hashed."
您会注意到，我们直接访问空间数据类型ST_Geometry的4个属性，以避免陷入生成的列的麻烦当中。
You will notice that we access four attributes of the spatial data type ST_Geometry directly to not run into trouble with the generated column.
同样，我使用% freedb_searches散列来生成一个检索的列表。
Again, I use the % freedb_searches hash to make a list of searches.
应用推荐