Li Ji
Abstract
With the rapid growth of the data in the database application, the performance optimization of the database system becomes more and more important.This article discusses the factors that affect the performance of SQL Server. The technology of the query mechanism and the query optimization of SQL Server were investigated.
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.
With the rapid growth of the data in the database application, the performance optimization of the database system becomes more and more important.This article discusses the factors that affect the performance of SQL Server. The technology of the query mechanism and the query optimization of SQL Server were investigated.
Key concepts: Computer science, Query optimization, Query by Example, Sargable, Data Transformation Services, Database, SQL, View