Step 5: Create indexes over MQTS.
步骤5:在MQT上创建索引。
创建索引(1秒)。
Create indexes on a Unicode tables.
在unicode表上创建索引。
Be careful when you manually create indexes.
在您手动创建索引时要谨慎操作。
You have the SQL code to create indexes.
你的SQL代码来创建索引。
For example, you can now create indexes and generate statistics on them.
比如,可以在上面创建索引和生成统计结果。
Create indexes for the column that your application is querying or updating.
为应用程序将查询或更新的列创建索引。
As of DB2 9, we can also CREATE indexes with columns that we designate as RANDOM.
至于DB 29,我们也可以使用我们指定为RANDOM的列create索引。
In the next section, you will learn how to create indexes to speed up your queries.
在下一节中,您将学习如何创建索引来加速查询。
Noise words: When you create indexes, you need to consider what Oracle calls "noise words."
干扰字:当您创建索引时,您需要考虑Oracle所称的“噪声码。”
We are updating the database this afternoon. Things may be slow while we create indexes.
今天下午升级数据库。创建索引时可能导致系统反应变慢。
When you create indexes, they will automatically use a default stop list to ignore noise words.
当您创建索引时,它们将会自动地利用一个默认地停止列表来忽略掉这些噪声码。
However in edge use cases, you might want to manually create indexes to speed up certain operations.
但是在边缘用例中,您可能想要手动创建索引,以便加速特定的操作。
Create indexes over the fields in data stores that are frequently referenced by query criteria.
创建索引查询数据在存储领域中经常引用的标准。
We parse the XML files beforehand to create indexes of content, and then search the indexes. 4.
检索过程中首先对XML描述文件进行预解析,建立动态的内容索引,然后对索引进行检索。
You can create indexes on one or more columns of a table to speed SQL statement execution on that table.
用户可以在表的一列或数列上建立索引,以提高在此表上执行sql语句的性能。
It can create indexes of word prefixes of arbitrary length and indexes of infix substrings of varying lengths.
它可以创建任意长度的单词前缀索引和可变长度的中缀子字符串的索引。
The most straightforward way to create indexes is using a command line interface that allows queries to be run.
创建索引最直截了当的方式,就是采用可以运行查询的命令行接口。
RDBMS-like attribute indexing support, where you can create indexes directly on selected attributes of a document.
类似于rdbms的属性索引支持,您可以直接在文档的选定属性上创建索引。
The indexes view allow you to create indexes for the table by selecting from the list of columns defined for the table.
允许您为表创建索引,只需要从为表定义的列列表中进行选择。
The Indexes view allows you to create indexes for the table by selecting from the list of columns defined for the table.
Indexes视图允许通过从为表定义的列列表中作出选择来创建索引。
However, it is preferable to create indexes before performing the LOAD command, and collecting statistics during the LOAD.
不过,最好是在创建索引之后再执行LOAD命令,并在LOAD期间收集统计信息。
When you create indexes on VARCHAR or VARGRAPHIC columns in your Unicode tables, you need to pay attention of the index key limit.
在unicode表中的VARCHAR或VARGRAPHIC列上创建索引时,需要注意索引键限制。
For example, some allow you to create indexes on the data, while others have the capability to configure caching and buffering options.
例如,某些机制允许您在数据上创建索引,而其他机制能够配置缓存和缓冲选项。
For more information on how to configure and create indexes for particular attributes on your LDAP, refer to your vendor-specific documentation.
有关如何配置LDAP的特定属性并为其创建索引的更多信息,请参考特定于提供商的文档。
Another limitation is that you cannot create indexes on TimeSeries virtual tables. Listing 11 shows how to build virtual tables for the baseball example.
另一个限制是,不能在TimeSeries虚表上创建索引。
The output file generated by the Design Advisor contains a set of DDL statements that create MQTs, refresh and update statistics on the MQTs, and create indexes on them.
Design Advisor生成的输出文件包含一组ddl语句,用于创建MQT、刷新和更新MQT上的统计信息,以及在其上创建索引。
Create your indexes in the order in which you want those index column predicates applied.
按照您想应用索引列谓词的顺序创建您的索引。
Listing 5 shows how to create these indexes.
清单5展示了如何创建这些索引。
In this example, we create functional indexes on the average color values of the pixels in a digital image.
在这个例子中,我们将针对一副数字图像的像素平均色值创建函数索引。
应用推荐