RE: external tables

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 30 Jul 2004 09:37:14 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DE3C@usahm018.exmi01.exch.eds.com>

Fred, External tables are just sqlldr executed from within the db. I haven't noticed any real time difference from insert select from external_table verse loading the same target via an external sqlldr. Do you have any test results you can share?

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Fuad Arshad Sent: Thursday, July 29, 2004 10:47 PM
To: oracle-l_at_freelists.org
Subject: Re: external tables

external tables are normally fast without indexes as they rely on fs access time .
on the other hand i use them exclusively for loading data in my dw. so its sure beats thetime taken by loading the time that sqlloader takes to load the data and process it.

susan lam <susanzlam_at_yahoo.com> wrote:
Hi,
I've a huge flat file (about 20GB) to load into a 9i database. I would like to make use of the external table feature but I do not know the usefulness of it if I cannot create any indexes on external tables. Querying on the table will be slow without the indexes. Are there other alternatives where I could make use of the external table feature and yet be able to query the table without any performance impact?

TIA susan

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Fri Jul 30 2004 - 08:35:36 CDT