ScholarLens Back to search
2011•Computer Knowledge and TechnologyRequires access

Based on ORACLE Database SQL Statement Optimization Analysis

Guo Xia

Open publisher page 1 citations

Abstract

With the database technology to various disciplines,due to the constant expansion of the database,database system performance is increasingly prominent,so the optimization method to explore the database,the database system can ensure stable and efficient operation with of crucial importance.In this paper,Oracle SQL tuning and optimization of the database,discusses the purpose and principles of SQL optimization,and through a number of examples,describes some of the ways to optimize SQL statements.

About this research paper

What this paper is about

With the database technology to various disciplines,due to the constant expansion of the database,database system performance is increasingly prominent,so the optimization method to explore the database,the database system can ensure stable and efficient operation with of crucial importance.In this paper,Oracle SQL tuning and optimization of the database,discusses the purpose and principles of SQL optimization,and through a number of examples,describes some of the ways to optimize SQL statements.

Why it matters

OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.

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

With the database technology to various disciplines,due to the constant expansion of the database,database system performance is increasingly prominent,so the optimization method to explore the database,the database system can ensure stable and efficient operation with of crucial importance.In this paper,Oracle SQL tuning and optimization of the database,discusses the purpose and principles of SQL optimization,and through a number of examples,describes some of the ways to optimize SQL statements.

Key concepts: Computer science, PL/SQL, Database, SQL, Oracle database, Oracle, Autocommit, Stored procedure

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Based on ORACLE Database SQL Statement Optimization Analysis — Research Paper | ScholarLens