摘要
查询优化是数据库的一项重要的性能,查询优化即是提高SQL的执行效率,从而提高数据库性能。该文以SQL Server为例,从减少计算量和内存使用量的角度,提出了一些新的查询优化方案,有效提高数据库查询效率。
As one of the most important performances of data base,query optimization aims to improve the efficiency of SQL,thus to promote data base performance.Taking SQL Server as an example,this paper puts forward some new query optimization schemes from the standpoint of reducing calculation amount and memory usage to effectively improve the database query optimization efficiency.
出处
《电脑知识与技术（过刊）》
2011年第10X期7085-7087,共3页
Computer Knowledge and Technology
