Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Insert Performance Question

Re: Insert Performance Question

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 27 Feb 2001 23:08:37 -0800
Message-ID: <3A9CA3F5.84C56485@exesolutions.com>

> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US