Archives of the TeradataForum
Message Posted: Fri, 25 Sep 2009 @ 13:55:16 GMT
| Subj: | | Re: Finding out the datablock size in Teradata |
| |
| From: | | Victor Sokovin |
| | How can we find out the size of datablock in Teradata. Is there any DBC table which stores this? | |
| | Can there be multiple data block sizes? | |
There is a system-wide default datablock size but it can be changed on the table level. Not only at the moment of table creation but at any
time time with the ALTER TABLE statement.
Check out the following thread in the archives for recommendations on how to look up the parameter and find out more om dynamic block
allocation:
www.teradataforum.com/teradata/20071212_180752.htm
Victor
| 
