2011•Computer Knowledge and TechnologyRequires access

Research of Query Optimization Based on SQL Server

Chen Zhen-bing

Abstract

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.

About this research paper

What this paper is about

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Key concepts: Computer science, Query optimization, Sargable, Query by Example, SQL, Database, Data Transformation Services, Stored procedure