RE: external tables

i've got a small whitepaper of the tests we conducted in house. will send as 
soon as i get  back to work monday.
although  your theory  is true. since there  is no loading pe say involved you 
can  query immediately versus wait for a load to complete which helps in  
scaling down  load times for stuff you just want to add or update in another 
table or plain just query . Save's a lot of db space  and can be used for 
archiving data.
"Powell, Mark D" <mark.powell@xxxxxxx> wrote:
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Fuad Arshad
Sent: Thursday, July 29, 2004 10:47 PM
To: oracle-l@xxxxxxxxxxxxx
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 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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: