So far, the power of full-text indexes is not fully exploited yet.
到目前为止,还没有充分揭示全文索引的实力。
Create full-text indexes on databases that are searched regularly.
在需要定期进行搜索的数据库上创建全文索引。
Full-text searches are only possible on columns that have active full-text indexes.
全文搜索仅适用于具有活动的全文索引的列。
For more information on full-text indexes and the CONTAINS clause, see your database documentation.
有关全文索引和CONTAINS子句的更多信息,请参见您的数据库文档。
It is not the managing of the full-text indexes that takes a lot of resources, but the actual searches.
管理全文索引并不需要大量资源,但是实际的搜索需要大量资源。
Text indexes can be created on a range of data types from small VARCHARs to large BLOBs that contain text objects.
文本索引可以在广泛范围的数据类型中创建,包括小型的VARCHAR和大型的BLOB等包含文本对象的数据类型。
After enabling a database for text, you can create text indexes on columns storing textual data in various formats, such as XML.
在为数据库启用文本搜索操作之后,可以在以各种格式(比如xml)存储文本数据的列上创建文本索引。
One full-text catalog can have several full-text indexes, but a full-text index can only be part of one full-text catalog.
一个全文目录可以包含多个全文索引,但一个全文索引只能用于构成一个全文目录。
The text indexes the approaches for improving its quality from basic theory, machines, tools and art innovations, and so on.
从基础理论、机床、刀具和技术创新等角度,指出了提高产品质量的途径。
Consider utilizing commands to back up DB2 Content Manager databases and objects residing in /lbosdata and text indexes into the same script.
考虑利用命令将 /lbosdata和文本索引中的DB2ContentManager数据库和对象备份到同一脚本。
Extensions to the create index statement enable administrators to create full text indexes to help improve the performance of such searches.
对CREATEindex语句的扩展使管理员能够创建全文索引,从而帮助改进这种搜索的性能。
The core search service stores the full-text indexes together with the collection configuration, including content sources and taxonomies in the file system.
核心搜索服务把全文索引和集合配置保存在一起,包括文件系统中的内容源和分类。
If you allow full-text indexes to be used on your DPARs, then you must not only account for the management of these indexes, but also the searches performed on these indexes.
如果允许在DPAR中使用全文索引,则不但必须考虑这些索引的管理,还要考虑在执行索引上执行的搜索。
As for objects residing in /lbosdata and DB2 NSE text indexes, to restore them from Tivoli Storage Manager, enter the following command (the same command as shown in previous listings)
对于 /lbosdata和DB2NSE文本索引中的对象,要通过TivoliStorageManager还原它们,输入以下命令(前面的清单列表已展示过相同的命令)
We show how large mail files can affect server performance, and offer tips for reducing database and Inbox size, the cost of full-text indexes, and other ideas for users, administrators, and planners.
还展示了大邮件文件是如何影响服务器性能的,并提供了减小数据库、收件箱大小以及全文索引开销的技巧,以及其他为用户、管理员和设计人员提供的方法。
You can re-index the multiline text fields by following the same procedures used to create the indexes on the original user database.
您可以通过下面的与在原始用户数据库上创建索引一样的步骤来对多行文本域进行重新检索。
An indexing engine, which defines the strategy to use for text analysis (the analyzer) and the index storage to use to record indexes.
索引引擎,用于定义文本分析(分析程序)所用的策略和用于记录索引的索引存储。
The text search index data is stored outside of DB2 in the integrated file system, much like regular DB2 text search indexes.
文本搜索索引数据存储在DB2之外的集成文件系统中,与常规DB 2文本搜索索引非常类似。
Re-index when moving databases:Whenever user databases are moved, the indexes that support multiline text fields are lost.
移动数据库时重新检索:只要用户的数据库被移动,支持多行文本域的索引就会丢失。
This row includes a value that allows indexes to be created for multiline text fields.
这个行包括一个允许为多行文本域创建索引的值。
Enter this command to delete the value in the table that allows indexes to be created for multiline text fields.
键入这个命令来删除表格中允许为多行文本文件创建索引的值。
For example, the index extension for the inverted text index can be parameterized to also support case-sensitive and case-insensitive indexes.
例如,将反向文本索引的索引扩展参数化,以支持大小写敏感和大小写不敏感的索引。
Run an SQL script to build the indexes for all multiline text fields that will be used for queries.
运行一个sql脚本来为所有将要被查询的多行文本域建立索引。
Build indexes for all multiline text fields that will be indexed.
为所有将被索引的多行文本域建立索引。
Optim Query Tuner provides reports in HTML and text format that contain information about the tables, indexes, and predicates that are involved with a particular SQL statements.
OptimQueryTuner提供了HTML和文本格式的报表,其中包含表、索引和谓词,这些都包含在一个特定的sql语句中。
The XSLT style sheet indexes into the dictionary, finds the key that matches the value of the nlsid attribute, matches the current language in the dictionary, and retrieves the translated text.
xslt样式表为字典编制索引、查找与nlsid属性值匹配的密钥、与字典中的当前语言匹配并检索已翻译的文本。
(Note, however, that view indexes and the full-text index may still be large).
(然而要注意,视图索引和全文本索引可能仍然很大)。
Step 3. Build indexes for all multiline text fields that will be indexed.
步骤3.为为所有将要被索引的多行文本予建立索引。
You can create text search indexes on the XML document.
可以为XML文档创建文本搜索索引。
By default, eXist indexes element and attribute nodes as well as the full text of the document.
默认情况下,eXist对元素和属性节点以及文档的全部文本做索引。
应用推荐