| 关系数据库更新查询的优化技术 |
| |
| 引用本文： | 董宇澄. 关系数据库更新查询的优化技术[J]. 电脑学习, 2005, 0(3): 64-64,F003 |
| |
| 作者姓名： | 董宇澄 |
| |
| 作者单位： | 江苏无锡商业职业技术学院 |
| |
| 摘 要： | 大型数据库的数据更新常常因为响应速度而深受影响,因此对于执行更新操作的UPDATE语句要进行优化,合理书写条件语句,并要结合索引的灵活使用,最终达到提高系统的响应速度,优化系统性能的目的.
|
| 关 键 词： | 更新查询 优化 索引 教据库 |
Optimization Technique of Update Query in Relational Database |
| |
| Dong Yucheng. Optimization Technique of Update Query in Relational Database[J]. Computer Study, 2005, 0(3): 64-64,F003 |
| |
| Authors: | Dong Yucheng |
| |
| Affiliation: | Dong Yucheng |
| |
| Abstract: | Data updates are influenced constantly by response speed in large database such as SQL server2000,so it is nec-essary to optimize the clauses which execute update operation.Using conditional if-statement with reason and co-njoining to the skilled index,the aim that speeds up access of system and opeimizes system performance achieve. |
| |
| Keywords: | SQL |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
