Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> external tables
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
![]() |
![]() |