The Key of Network Database Optimization

Database management system is the core of management information system.The entire table scanning usually needs dozens of minutes if a database table includes millions of records,which will cause the decrease of efficiency of the developed system. The users cannot bear that,which shows the importance of network database optimization.There are many factors that can affect the performance of database.This paper takes SQL Server as an example,introduces how to optimize the network database from the logical database design,query design and index design aspects.The paper also proposes some principles and methods of optimization from the application point of view to improve the efficiency of management information system.