摘要
数据库技术是计算机信息系统和应用系统的重要基础。基于开发人员在关系型数据库系统中SQL检索效率低下的问题,对数据库的执行计划和索引做出了详细介绍。运行执行计划我们可以发现需要优化的地方,结合实际项目的代码示例,可以看出通过对索引进行优化,确实可以显著提升SQL检索效率的结论。本文主要从索引优化的角度出发,提升了SQL检索的效率,并且归纳出SQL检索优化的常用方法,然后总结了SQL数据库优化过程中的注意事项。
Database technology is an important foundation of computer information system and application system.Based on the inefficiency of SQL retrieval in relational databases system by developers,this paper introduces the execution plan and index of database in detail.The execution plan can find the places that need to be optimized,by optimizing the index,the efficiency of SQL retrieval can be significantly improved by the code examples of actual projects.This paper mainly from the viewpoint of index optimization,improves the efficiency of SQL retrieval,and summarizes the common methods of SQL retrieval optimization,and then summarizes the matters needing pay attention in the process of SQL database optimization.
作者
徐昂
成科扬
XU Ang;CHENG Ke-yang(School of Computer Science and Telecommunication Engineering,Jiangsu University,Zhenjiang 212013,China)
出处
《电子设计工程》
2019年第11期51-55,共5页
Electronic Design Engineering
关键词
数据库
查询
优化
SQL开发
database
query
optimization
SQL development
