 |
 |
Archives of the TeradataForum
Message Posted: Wed, 26 Apr 2006 @ 14:13:49 GMT
| Subj: | | Re: Question about TD block assigning |
| |
| From: | | John Graas |
TeradataForum wrote:
| | When I insert one new row into TD db, if the current data block doesnot stand enough room for that new row, Here are two ways TD will
act, | |
| | Expand current data block to hold that new row | |
| | Asking for new data block with enough room from free cylinder list, and copy data from old block to new block, placed the old block to the
free cylinder list, | |
| | My question is at what occasion td will act in the first way, what occasion for sencond way? | |
My best memory is that Teradata will always write a new block and delete the old unless there is an Update Row that does not impact the row
size.
jdg
www.jgraas.com
| |
