SQL语句的优化与性能调优  

SQL Statement Optimization and Performance Tuning

作　　者：吴凯佳 陈少琴[2] 李结映 WU Kai-jia;CHEN Shao-qin;LI Jie-ying(Affiliated Tumor Hospital of Shantou University Medical College Information Centre,Shantou Guangdong 515031;Affiliated Tumor Hospital of Shantou University Medical College Operation Room,Shantou Guangdong 515031;Affiliated Tumor Hospital of Shantou University Medical College Personnel Section,Shantou Guangdong 515031)

机构地区：[1]汕头大学医学院附属肿瘤医院信息科,广东汕头515031 [2]汕头大学医学院附属肿瘤医院手术室,广东汕头515031 [3]汕头大学医学院附属肿瘤医院人事科,广东汕头515031

出　　处：《数字技术与应用》2020年第5期51-51,53,共2页Digital Technology & Application

摘　　要：在日常的工作中,或多或少会遇到一些较为复杂的SQL语句,当我们发现这些语句执行得慢时,总是会想办法对其修改,让它变得更快一些。本文探讨研究了SQL SERVER下SQL的语句调优方法。In our daily work,we will encounter some more or less complex SQL statements,When we find that these statements execute slowly,we always try to modify them to make them faster.This paper discusses the optimization method of SQL statements under SQL server.

关 键 词：SQL 优化 调优 

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