| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: VARCHAR2(50) or VARCHAR2(256). Why do I care?
In article <80eu7b$7lo$1_at_autumn.news.rcn.net>,
"Alan Hopkins" <ahop_at_CYBERIA.COM> wrote:
> What's the performance implications of using 'correctly' sized (based
on
> usage) of columns, vs. making these sizes excessive?
> Are there network implications? Database implications?
>
No storage implications or network implications.
Report writers, sql*plus etc. use the maximum length to automatically
set the field width for each column included in a report. Programs
that generate database user interface use the maximum length when
generating the size of controls (i.e. the size of the edit box).
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Nov 11 1999 - 13:24:43 CST
![]() |
![]() |