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: VARCHAR2(50) or VARCHAR2(256). Why do I care?

Re: VARCHAR2(50) or VARCHAR2(256). Why do I care?

From: Ben Ryan <benryan_at_my-deja.com>
Date: Thu, 11 Nov 1999 19:24:43 GMT
Message-ID: <80f55f$8jd$1@nnrp1.deja.com>


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

Original text of this message

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