Re: Slooow Import
Date: 1996/04/22
Message-ID: <4lgurn$6mn_at_nntpa.cb.att.com>#1/1
> ...
>
>According the Oracle hotline support import should work in the following way:
>First the data table is imported and then the index is added. ?????
>I do not known if I belive this, because import is real slow.
>
>Bjarne Ebsen
>be_at_cci.dk
>
I've treid to import a large table with indexes = n, i.e. I tell import
not to import the indexes, and this isn't much faster than a "normal"
import. I believe the reason is because import works as described above,
i.e. it imports the data and then creates the indexes. When I import, I
get a message like "Imported 222,000 rows" which I believe means the
data import has completed and then import sits there for a while before
actually completing, which I believe is the index building phase.
--
Joe Miklewicz 908-949-3061 jmjm_at_hogpa.att.com
Received on Mon Apr 22 1996 - 00:00:00 CEST