Research on query optimization methods based on relational database
PU Hui-zhong
Abstract
PU Hui-zhong
Abstract
Generally,how to improve the operation speed and execution efficiency is an important symbol for testing the performance of the relational database system.There are many places which need to be optimized,including several stages such as logic design,physical design and query.Query operation constitutes the majority among them,so we can say the query speed determines the performance of the relational database.This paper focuses on the query optimization methods and analyzes them with the practical application examples.
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.
Generally,how to improve the operation speed and execution efficiency is an important symbol for testing the performance of the relational database system.There are many places which need to be optimized,including several stages such as logic design,physical design and query.Query operation constitutes the majority among them,so we can say the query speed determines the performance of the relational database.This paper focuses on the query optimization methods and analyzes them with the practical application examples.
Key concepts: Computer science, Query optimization, Sargable, View, Relational database, Query by Example, Relational model, Relational database management system