摘要
大型数据库的数据更新常常因为响应速度而深受影响,因此对于执行更新操作的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.
出处
《电脑学习》
2005年第3期64-64,F003,共2页
Computer Study
