Re: Average Row Length Question

From: <nasof_at_my-dejanews.com>
Date: Tue, 30 Jun 1998 17:07:52 GMT
Message-ID: <6nb618$ami$1@nnrp1.dejanews.com>

You might need to add 3 bytes for the row-header, plus 1 byte for every field into the average

-Frank

In article <3598F576.85DA30F1_at_umbc.edu>, Todd Haddaway <haddaway_at_umbc.edu> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jun 30 1998 - 12:07:52 CDT