 |
 |
Archives of the TeradataForum
Message Posted: Mon, 18 Jan 2016 @ 16:36:12 GMT
| Subj: | | Re: Partition primary Index |
| |
| From: | | Levai Akos |
Sorry, I've forgot one more important advance of the partitioning: if you do not use the partitioning key for filtering very often, but just
use some "advancing" values for partitioning, like the transaction date, then the data loaded closely to together in time will reside "closely". I
mean not distributed evenly throughout the table blocks, but will fill up quite few data blocks. Therefore the load procedure will be much faster.
Not to mention the ageing (delete) of old data.
In this case I do not see this kind of advance either.
Br,
Akos
| |
