2006•Unpublished venueRequires access

Using the ORACLE LIBNAME Engine to Reduce the Time It Takes to Extract Data From an ORACLE Database

David Chapman

Abstract

This paper reviews the ORACLE LIBNAME engine and shows how to use it to extract data from an ORACLE Database. Common parameters for the ORACLE LIBNAME engine are illustrated. We discuss issues related to reporting resource usage. ORACLE hints are described and explained as a way to reduce the time it takes to extract data from an ORACLE table and to improve processing. Several examples of ORACLE hints are given. The paper discusses the use of ORACLE indexes as a way to improve efficiency and avoiding sorting. Examples are given of the use of the DBKEY option to efficiently extract part of an ORACLE table.

About this research paper

What this paper is about

Why it matters

OpenAlex reports 3 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

Key concepts: Oracle, Oracle Unified Method, Computer science, Oracle database, Database, PL/SQL, Table (database), Sorting