Subject Average record length interpretation
Author kopaka4@gmail.com
Hello,

Seems I have problem with unused versions of rows in one table. Can you
advice me, how to interpret Average record length and Average version
length ? Why is Average record length so small ?

SELDAT (147)
Primary pointer page: 218, Index root page: 219
Average record length: 0.21, total records: 1584809
Average version length: 22.87, total versions: 1575168, max versions: 1
Data pages: 23833, data page slots: 25638, average fill: 93%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 157
80 - 99% = 23675


table itself consists only from 2 fields, each of those fields is
varchar(10) and each field in each record contains string with length
10. Both fields together are unique, but there is no index around it, it
is based on how we work with table.

thanks, tomas