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 -> Insert Performance Question

Insert Performance Question

From: George Eidman <geidman_at_voicenet.com>
Date: Wed, 28 Feb 2001 01:02:36 GMT
Message-ID: <M6Ym6.452$T7.12633@news2.voicenet.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 .

Thanks Received on Tue Feb 27 2001 - 19:02:36 CST

Original text of this message

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