Re: Average Row Length Question

From: JHY <jhy_at_earthling.net>
Date: Tue, 30 Jun 1998 12:43:42 -0400
Message-ID: <6nb4jj$9sb@bgtnsc03.worldnet.att.net>

Each VARCHAR2 column has 1 or 2 bytes of overhead (to store the actual length I believe). This is where the extra few bytes come from.

Todd Haddaway wrote:

> I have a table that the sum of the field lengths is 100
> bytes/characters. If I do a:
> SELECT AVG_ROW_LEN FROM USER_TABLES
> I notice that the average row length is 107. How can this be?? I would
> think the max row length is 100 and the average couldn't be any greater.
>
> What gives??
>
> --
> Todd Haddaway University Computing Services
> Technical Architect University of Maryland Baltimore County
> voice: (410) 455-2854 Central Facilities Room 115B
> fax: (410) 455-1069 1000 Hilltop Circle
> email: haddaway_at_umbc.edu Baltimore MD, 21250
Received on Tue Jun 30 1998 - 11:43:42 CDT