摘要
数据库是应用程序的核心,为提高基于SQL Server数据库应用程序的执行效率,本文分析了SQL Server数据库的查询优化处理技术,分别讨论了建立索引,避免SQL排序,优化多表查询等技术,从而优化SQL查询的性能。
Database is the core of applicable program, the essay analyzed inquiry optimizing processing technology of SQL Server database to improve executing efficiency and respectively discussed technologies as establishing indexes, avoiding SQL compositor, optimizing inquiry to promote its properties.
关键词
性能优化
索引
排序
内嵌视图
Property Optimizing
Index
Compositor
In - line Viewgraph
