Research of Optimum Query Technology on Clob Big Segment in Oracle Database
Zhao Jian-min · Computer Technology and Development · 2006
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 proposes 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.