摘要
随着数据库技术应用到各个学科领域,由于数据库规模的不断扩大,数据库系统的性能问题越来越突出,因此对数据库优化技术方法的探索,对确保数据库系统能否稳定、高效的运行有着至关重要的意义。该文针对Oracle数据库的SQL调整和优化,论述了SQL优化的目的和原则,并通过若干实例,介绍了SQL语句优化的一些方法。
With the database technology to various disciplines,due to the constant expansion of the database,database system performance is increasingly prominent,so the optimization method to explore the database,the database system can ensure stable and efficient operation with of crucial importance.In this paper,Oracle SQL tuning and optimization of the database,discusses the purpose and principles of SQL optimization,and through a number of examples,describes some of the ways to optimize SQL statements.
出处
《电脑知识与技术》
2011年第7X期5063-5065,共3页
Computer Knowledge and Technology