摘要
在系统的应用过程中,数据库性能问题一直是决策者和技术人员共同关注的焦点,影响数据库性能的因素有很多,选择合适的索引能有效地提升查询性能。在select和where子句的列上创建连接索引,这样查询就只会访问索引,从而优化查询的性能,提升系统响应速度,节约系统资源。
In the application process of the system,database performance is always the focus of policymakers and technicians,there are many factors that affect the database performance,choose the appropriate index can effectively improve query performance.To create the connection index on the select and the where clause on a column,so the query will only visit the index,and to optimize query performance,improve the response speed of the system,saving system resources.
作者
邢晨
安义
XING Chen,AN Yi（Military Economy Academy,Wuhan 430035,China）
出处
《电脑知识与技术》
2013年第5期2967-2968,2972,共3页
Computer Knowledge and Technology
