Models of optimization in application program of SQL server database
GU Zhen-li · Jisuanji gongcheng yu sheji · 2006
In order to improve execute efficiency of application program in SQL server database. Query optimization technology from application program in SQL server database is analyzed. Models of optimizing application in SQL server database is presented, including selecting optimizing superior server; optimizing database design; using procedure; using query efficiency SQL language; using affair and batch; avoid backup; select develop tools and adopt efficiency database access technology.