| SQL Sever 2000系统编程时的性能优化 |
| |
| 引用本文： | 周成义. SQL Sever 2000系统编程时的性能优化[J]. 鞍山科技大学学报, 2005, 28(1): 41-42 |
| |
| 作者姓名： | 周成义 |
| |
| 作者单位： | 鞍山科技大学高等职业技术学院,辽宁鞍山114044 |
| |
| 摘 要： | SQL Sever 2000作为一种普遍应用的大型数据库管理系统，其优化技术在数据库应用中尤显重要。从减少数据传输、避免使用LIKE搜索条件、使用分组字段等方面介绍如何优化查询设计；从使用UPDATE数据库更新、使用索引、防止死锁及死锁处理等方面介绍在数据维护时的性能优化。
|
| 关 键 词： | 查询 数据维护 优化 死锁 |
| 文章编号： | 1672-4410(2005)01-0041-02 |
| 修稿时间： | 2004-05-20 |
Property optimization of SQL Server 2000 for system programme |
| |
| ZHOU Cheng-yi. Property optimization of SQL Server 2000 for system programme[J]. Journal of Anshan University of Science and Technology, 2005, 28(1): 41-42 |
| |
| Authors: | ZHOU Cheng-yi |
| |
| Abstract: | SQL Server 2000 is a commonly applied large DBMS,and the optimization technology is very important in its application.How to optimize query design was introduced in such aspects as to reducing data transfer,avoiding using LIKE searching requirements,and using grouped fields.The property optimization in data maintenance was presented in such aspects:the update of database,the use of index and the prevention of dead lock as well as how to deal with it when it happens. |
| |
| Keywords: | query data maintenance optimization deadlock |
| 本文献已被 CNKI 维普 等数据库收录！ |
