首页 | 本学科首页   官方微博 | 高级检索  
     

数据库SQL查询技术的优化策略
引用本文:谭定英,方振聪. 数据库SQL查询技术的优化策略[J]. 计算机与现代化, 2005, 0(6): 67-69
作者姓名:谭定英  方振聪
作者单位:广州中医药大学信息技术学院计算中心,广东,广州,510405;广州中医药大学信息技术学院计算中心,广东,广州,510405
摘    要:在数据库应用系统的开发过程中,若不注重SQL的查询优化策略,往往在系统初步投入使用时比较流畅,但随着数据库表中记录的日积月累数量越来越大,系统的响应速度越来越慢,甚至让人无法忍受,就有可能导致系统被淘汰。因此,科学合理地构造查询系统,是成功开发数据库应用系统非常重要的环节。本文结合数据库理论,并以学生信息管理系统为例,就查询优化必要性及如何进行数据库查询优化的策略进行探讨。

关 键 词:数据库  SQL  查询优化
文章编号:1006-2475(2005)06-0067-03
修稿时间:2004-09-06

Optimization Strategy of SQL Inquiring Database
TAN Ding-ying,FANG Zhen-cong. Optimization Strategy of SQL Inquiring Database[J]. Computer and Modernization, 2005, 0(6): 67-69
Authors:TAN Ding-ying  FANG Zhen-cong
Abstract:During the development of database application system, if one does not pay attention to optimization policy of SQL query, everything seems quite smooth in the initial use of the system. But as the database is filled with more and more information, the responding speed will be slowed down, even to an unbearable extent, which probably leads to the elimination of the system through the contest. Thus, it is key to develop database application system successfully that one formats the query system in a logistic and reasonable way. This article is to probe into the need of query optimization and how to optimize database query. Database theory is used in this article and student information management system is taken as example.
Keywords:database  SQL  query optimization
本文献已被 CNKI 维普 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号