【摘要】 SQLSever2000作为一种普遍应用的大型数据库管理系统,其优化技术在数据库应用中尤显重要。从减少数据传输、避免使用LIKE搜索条件、使用分组字段等方面介绍如何优化查询设计;从使用UPDATE数据库更新、使用索引、防止死锁及死锁处理等方面介绍在数据维护时的性能优化。更多还原

【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.更多还原