Research of Query Optimization Based on SQL Server
Chen Zhen-bing · Computer Knowledge and Technology · 2011
As one of the most important performances of data base,query optimization aims to improve the efficiency of SQL,thus to promote data base performance.Taking SQL Server as an example,this paper puts forward some new query optimization schemes from the standpoint of reducing calculation amount and memory usage to effectively improve the database query optimization efficiency.