2009•Computer Knowledge and TechnologyRequires access

SQL Statement in Database Systems to Optimize

Wenqiang Song

Abstract

The database query is the most basic and commonly used,the most complex operation,query the merits of operating a direct impact on the performance of database applications.This article discusses the technology based on SQL query rewriting the database query optimization strategies,through query rewriting can be written by the user efficiency of SQL statements to re-optimize the portfolio to become more efficient query.

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, Query by Example, Sargable, Query expansion, View, SQL, Query language