Robert Klemme wrote:
> 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
Oops. An attempt at humor shot down in flames. I meant to say INvalid
syntax is faster. <g>
--
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
Received on Thu Aug 23 2007 - 18:13:13 CDT
