Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert Performance Question
> Do column defaults affect insert performance?
>
> I'm setting a date column to SYSDATE. Would a insert statement be faster (In
> a PL/SQL procedure) if a date is set by a column default to SYSDATE and not
> specify the column in my insert statement .
One of them is undoubtedly faster than the other. But I doubt you could tell the difference unless you did them by the tens of thousands.
I have a rule, however, never to use the DEFAULT syntax as it obscures what is happening.
Daniel A. Morgan Received on Wed Feb 28 2001 - 01:08:37 CST