在需要定期进行搜索的数据库上创建全文索引。
Create full-text indexes on databases that are searched regularly.
这些列可用于创建全文索引。
创建全文索引时选择语言。
创建全文索引时，建议为每个索引列都指定一种语言。
When creating a full-text index, we recommend that you specify a language for each indexed column.
如果要选择用于创建全文索引的列语言，有几个事项需要注意。
There are a couple of things to consider when choosing the column language for creating a full-text index.
基于这个测试我们得出：如果需要定期搜索数据库，创建全文索引通常是较好的做法。
Based on this test, we concluded that if databases are searched regularly, it is generally better to create a full-text index.
即使支持900字节的列，也不建议您使用这么大的键列来创建全文索引。
Although a 900-byte column is supported, we do not recommend building a full-text index that USES a key column of that size.
对CREATEindex语句的扩展使管理员能够创建全文索引，从而帮助改进这种搜索的性能。
Extensions to the create index statement enable administrators to create full text indexes to help improve the performance of such searches.
这意味着可以对其他人拥有的数据库执行这些搜索，而您是无法在该数据库中创建视图或全文索引的。
This means that you can perform these searches against a database owned by other people in which you have no ability to create views or a full-text index.
清单4中的命令在“product”表的“description”列中本机存储的XML文档上创建一个名为“ix1”的全文索引。
The command in Listing 4 creates a full-text index named "ix1" on the XML documents that are stored natively in column "description" of table "product."
清单4中的命令在“product”表的“description”列中本机存储的XML文档上创建一个名为“ix1”的全文索引。
The command in Listing 4 creates a full-text index named "ix1" on the XML documents that are stored natively in column "description" of table "product."
应用推荐