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 -> Does VARCHAR2 size matter?

Does VARCHAR2 size matter?

From: Morten <morten_at_kikobu.com>
Date: Wed, 06 Feb 2002 12:26:47 +0100
Message-ID: <3C6112F7.1070205@kikobu.com> 






Hi. What consequences are there when using VARCHAR2(4000) rather
than eg. VARCHAR2(500) columns? I'm wondering as VARCHAR2 is variable
length, if there are any major performance reasons to keep the
fields as small as possible, or if those reasons are more likely to
be from a constraining/modelling perspective.



Morten
Received on Wed Feb 06 2002 - 05:26:47 CST












Original text of this message













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