摘要
分析了影响SQLServer应用系统运行效率的主要因素,提出几种有效提高数据库性能的方法,并通过教务查分系统数据库设计方案对优化前后的查询效率进行对比,性能评测结果验证了方法的正确性。
It analyzes the main factors which affect the performance of SQL Server database application system, and puts forward several efficient ways to improve database performance. Besides, this paper compares the optimized efficiency with none - optimized efficiency of educational administration system which is presented as instance and validates such methods.
出处
《计算机与数字工程》
2005年第9期147-149,共3页
Computer & Digital Engineering
关键词
数据库
优化
索引
SQL语句
运行效率
Database, Optimizing, Index, SQL Language, Running Efficiency