Re: external tables
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 29 Jul 2004 19:46:52 -0700 (PDT)
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@xxxxxxxxx> 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
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
----------------------------------------------------------------
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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
