关系数据库更新查询的优化技术

Optimization Technique of Update Query in Relational Database

大型数据库的数据更新常常因为响应速度而深受影响,因此对于执行更新操作的UPDATE语句要进行优化,合理书写条件语句,并要结合索引的灵活使用,最终达到提高系统的响应速度,优化系统性能的目的。

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.