| 基于SQL Server的数据库查询优化分析 |
| |
| 引用本文： | 徐寿芳,方东傅.基于SQL Server的数据库查询优化分析[J].湖州职业技术学院学报,2006,4(3):86-88. |
| |
| 作者姓名： | 徐寿芳 方东傅 |
| |
| 作者单位： | 1. 湖州职业技术学院,经贸分院,浙江,湖州,313000
2. 湖州职业技术学院,理工分院,浙江,湖州,313000 |
| |
| 摘 要： | 优化数据库的整体性能是数据库技术的另一个研究热点。以SQL Server为基础,分析了数据库查询优化的常用方法:索引优化和SQL语句优化,证明可以提高数据库的整体性能。
|
| 关 键 词： | 索引 SQL SELECT语句 性能优化 |
| 文章编号： | 1672-2388（2006）03-0086-03 |
| 收稿时间： | 2005-12-25 |
| 修稿时间： | 2005-12-25 |
Database's Query Optimization Based on SQL Server |
| |
| XU Shou-fang,FANG Dong-fu.Database''''s Query Optimization Based on SQL Server[J].Journal of Huzhou Vocational and Technological College,2006,4(3):86-88. |
| |
| Authors: | XU Shou-fang FANG Dong-fu |
| |
| Institution: | 1. Faculty of Economy and Trade, Huzhou Vocational and Technological College, Huzhou 313000, China; 2. Faculty of Science and Engineering, Huzhou Vocational and Technological College, Huzhou 313000, China |
| |
| Abstract: | Optimizing the total performance of database has become another hot topic in database's technology.on the base of SQL Server,we talk about the method of database's query optimization:index optimization and SQL statement optimization,so as to improve database's total performance. |
| |
| Keywords: | index structure query language select statement performance optimization |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
