LAND Table Row Storage Size
Table - Sorted Table - Copybook - Create Table - Format File - Bulk Insert - Row Size - Back To Table Index

Column NameData TypeBytes Used
PROPERX_KEY BIGINT8
PROPERX_GRPCD TINYINT9
PROPERX_DISTRICT TINYINT10
LOTTYPE_TYPE_LOT TINYINT11
LOTTYPE_WET_LOT VARCHAR(1)12
LOTTYPE_SITE_VALUE INT16
PROPERTYPE VARCHAR(1)17
PROPER_NBR VARCHAR(2)19
O_UNPACKED VARCHAR(30)49
PROPER_CODE1 TINYINT50
PROPER_AMOUNT1 SMALLINT52
PROPER_CODE2 TINYINT53
PROPER_PERCENT2 DECIMAL(4,2)57
PROPER_VALUE INT61
PROPERX_ZONE VARCHAR(4)65
PROPER_AGRI_CODE VARCHAR(1)66
PROPER_AGRI_YEAR SMALLINT68
PROPER_EXCESS_FLAG VARCHAR(1)69
PROPER_EFF_YEAR SMALLINT71
PROPER_REAPPRAISAL INT75

20 columns are defined.

To Top - Print

Output Generated By +1DataElements From +1 Software Engineering LLC.
Created on: 23-MAY-2020 11:22 AM