Re: DS

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 23 Aug 2007 21:48:13 +0200
Message-ID: <5j66k0F3sd7aqU1@mid.individual.net>

On 23.08.2007 18:37, DA Morgan wrote:
> 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.

It depends on what you measure: typically the erroneous statement will terminate faster - at least if there is /some/ data to index. :-)

> There is no ALTER TABLE ADD INDEX syntax in Oracle.

Kind regards

robert, who is looking forward to get his hands on an Oracle system again Received on Thu Aug 23 2007 - 14:48:13 CDT