Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Loading data usng External Tables

RE: Loading data usng External Tables

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Tue, 29 Aug 2006 09:34:17 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5AE41@ex2.ms.polyserve.com>

         

>George,
>you can parallel either format (csv or fixed length),
>Fixed length is much faster as the system will not have to scan
the data to find out the ',' to delimit each field.         

...have you measured how much faster, or are you basing this on principle? I perform huge, high end loads from external tables and have achieved as much as 250,000/sec per CPU with variable length.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 29 2006 - 11:34:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US