Average Row Length Question

From: Todd Haddaway <haddaway_at_umbc.edu>
Date: Tue, 30 Jun 1998 10:25:58 -0400
Message-ID: <3598F576.85DA30F1@umbc.edu>

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 - 09:25:58 CDT