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

Home -> Community -> Mailing Lists -> Oracle-L -> external tables

external tables

From: susan lam <susanzlam_at_yahoo.com>
Date: Thu, 29 Jul 2004 16:12:30 -0700 (PDT)
Message-ID: <20040729231230.74831.qmail@web53310.mail.yahoo.com>


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_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 Thu Jul 29 2004 - 18:08:58 CDT

Original text of this message

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