Re: DS

Picaso.Leonardo_at_gmail.com wrote:
> What will work faster in Oracle for Import?
> CREATE INDEX or ALTER TABLE TAB ADD INDEX

Generally speaking valid syntax is faster as Oracle immediately throws an error message and doesn't do any real work.

There is no ALTER TABLE ADD INDEX syntax in Oracle.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org