All Forums Database
Cvinodh 32 posts Joined 10/11
06 Feb 2014
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.

Adeel Chaudhry 773 posts Joined 04/08
07 Feb 2014

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. :)

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.