Transcription of Using the ORACLE LIBNAME Engine to Reduce the …
{{id}} {{{paragraph}}}
1 Using the ORACLE LIBNAME Engine to Reduce the Time It Takes to Extract Data From an ORACLE Database David D. Chapman, Selvaratnam Sridharma, Census Bureau, Washington, DC ABSTRACT This paper reviews the ORACLE LIBNAME Engine and shows how to use it to extract data from an ORACLE Da-tabase. Common parameters for the ORACLE LIBNAME Engine are illustrated. We discuss issues related to re-porting resource usage. ORACLE hints are described and explained as a way to Reduce the time it takes to ex-tract 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.
1 Using the ORACLE LIBNAME Engine to Reduce the Time It Takes to Extract Data From an ORACLE Database David D. Chapman, Selvaratnam Sridharma, U.S. Census Bureau, Washington, DC
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}