Datablocksize and Freespacepercent

Database

Datablocksize and Freespacepercent

Does the properties of Table like Datablocksize and Freespacepercent is applicable to Spool?
in that case if we have a Table A with Datablocksize x1 and Freespacepercent x2 and Table B with Datablocksize y1 and Freespacepercent y2
what would be the Datablocksize and Freespacepercent of the resulting spool created by joining the two tables?

Note: The Freespace percent property for Spool doesn't make sense though.

1 REPLY
Teradata Employee

Re: Datablocksize and Freespacepercent

Data block is the physical I/O unit for the Teradata file system. Hence it should be the same.

FreeSpacePercent is the x percent free space that remains on each cylinder during bulk data load operations .... as bulk loading wont be done on spool table, hence it doesnt sound right. :)