Re: DS

On Aug 23, 3:24 am, Picaso.Leona..._at_gmail.com wrote:
> What will work faster in Oracle for Import?
> CREATE INDEX or ALTER TABLE TAB ADD INDEX

If you are asking about the imp utility and whether to use the indexes parameter, often it is faster to import the data without indexes and with the direct parameter, and then create the index afterwards using the command file you can create with the indexfile parameter. http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2783

It helps to always name constraints rather than let Oracle name them, too.

Please remember to give all relevant information with questions, see http://www.dbaoracle.net/readme-cdos.htm

jg

--
@home.com is bogus.
http://ask.slashdot.org/article.pl?sid=07/08/23/1447220