Oracle数据库中Clob大字段的查询优化技术研究  

Research of Optimum Query Technology on Clob Big Segment in Oracle Database

作　　者：聂红梅[1] 赵建民[1] 

机构地区：[1]浙江师范大学信息科学与工程学院,浙江金华321004

出　　处：《计算机技术与发展》2006年第8期97-99,102,共4页Computer Technology and Development

摘　　要：在数据量达到几十万的数据库中查询Clob字段,其响应的时间是影响数据库应用的关键技术。为了提高Oracle数据库中Clob大字段的查询速度以满足用户的需求,介绍了数据库参数配置、数据表结构配置、全文索引等常用的优化技术对查询进行优化,接着介绍了笔者在开发一个应用系统中采用的建立一个优化JOB、分区建立表、分区建立表全文索引和Oracle的并行执行等优化技术来进行调整和优化。使查询Clob字段速度得到了明显的提高,最终满足了用户的需要。The response time of querying the Clob field in a mass-data database is one of the key technologies influencing the database usage. This paper propce, es some common optimum technologies, such as configuration of the database parameters, configuration of the table structures and full - text indexing used to promote the query speed of the Clob big field in the Oracle database. Ways of optimizing and adjusting the database applied in an application system development are also introduced in this paper, including creating an optimum JOB, full - text indexing of tables section by section and parallel executing the Oracle database. All these technologies make a significant improvement in the speed of querying the big Clob field and satisfy the user＇s needs.

关 键 词：Clob字段 ORACLE数据库 优化索引 参数配置 全文检索 

分 类 号：TP311.5[自动化与计算机技术—计算机软件与理论]