Optimizing Methods for the Query Sentences in SQL
Chang Wei
Abstract
Chang Wei
Abstract
The optimization of query sentences is to select operation sequence with minimal costs in terms of given query so as to make query a time-saving and space-saving process.This paper introduces several kinds of optimizing methods for SQL query sentences based on the analysis on the performance factors of queries in the data base system.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
The optimization of query sentences is to select operation sequence with minimal costs in terms of given query so as to make query a time-saving and space-saving process.This paper introduces several kinds of optimizing methods for SQL query sentences based on the analysis on the performance factors of queries in the data base system.
Key concepts: Query optimization, Sargable, Computer science, Query by Example, SQL, Query language, Query expansion, RDF query language