Sql2005全文索引详解资源-CSDN文库

Sql2005

5星 · 超过95%的资源需积分: 9 6 浏览量 2008-02-27 10:01:11 上传评论收藏 583KB DOC 举报

资源推荐

资源详情

资源评论

Sql2005 全文索引详解
前言..........................................................................................................................................2
1 全文索引的介绍................................................................................................................2
2 全文索引中常用的术语....................................................................................................3
3 全文索引的体系结构........................................................................................................4
4 全文目录管理....................................................................................................................5
4.1 创建全文目录.........................................................................................................6
4.2 查看与修改全文目录.............................................................................................7
4.3 删除全文目录.........................................................................................................8
5 全文索引管理....................................................................................................................8
5.1 创建全文索引的注意事项.....................................................................................8
5.2 创建全文索引.........................................................................................................9
5.3 查看与修改全文索引...........................................................................................14
5.4 启用和禁用全文索引...........................................................................................15
5.5 删除全文索引.......................................................................................................16
6 填充全文索引..........................................................................................................16
6.1 填充全文索引的方式...........................................................................................16
6.2 填充全文索引.......................................................................................................16
6.3 定时填充全文索引...............................................................................................18
7 使用全文搜索查询..........................................................................................................21
7.1 使用 CONTAINS 搜索.........................................................................................21
7.2 使用 FREETEXT 搜索.........................................................................................27
7.3 使用 CONTAINSTABLE 搜索............................................................................28
7.4 使用 FREETEXTTABLE 搜索............................................................................31
7.5 搜索 image 字段...................................................................................................32
8 2005 新增：与全文索引相关的 T-SQL 语句................................................................33
8.1 创建全文目录.......................................................................................................33
8.2 更改全文目录属性...............................................................................................34
8.3 创建全文索引.......................................................................................................34
8.4 更改全文索引属性...............................................................................................35
8.5 删除全文索引.......................................................................................................37
8.6 删除全文目录.......................................................................................................37
9 小结..................................................................................................................................38