Re: Does VARCHAR2 size matter?

From: Andreas <andreas.prusch_at_t-online.de>
Date: 6 Feb 2002 05:50:59 -0800
Message-ID: <c071e7da.0202060550.42ffe0d8@posting.google.com>

Hi,

the length of the varchar2 column doesn't really matter. Because all columns (including number types) are stored in variable length format, there's no improvement in space usage.

Best regards;
Andreas

Morten <morten_at_kikobu.com> wrote in message news:<3C6112F7.1070205_at_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 - 07:50:59 CST