2007•Journal of Luoyang UniversityRequires access

Query Optimization of Relational Database Based on Index

Guofeng Ma

Abstract

Query optimization is a key technique for improving database performance.Based on the analysis of automatic query optimization of SQL Server relational database system,this paper introduces the category and use principles of index,and discusses many effective methods of query optimization based on index in SQL sentences via cases,which can promote the query efficiency of database.

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: Query optimization, Computer science, Sargable, Query by Example, View, Relational database, SQL, Index (typography)