|
|
Archives of the TeradataForum
Message Posted: Mon, 27 Jun 2011 @ 07:34:02 GMT
Subj: | | Re: MLPPI on date field |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Sunday, June 26, 2011 22:12 -->
Dieter Noeth wrote:
| When you access one year you'll scan those 12 monthly partitions either way. | |
Is there no downside to having more partitions? Would everyone then partition by a single day rather than week or month then?
Would having more partitions have any negative impact on full table scans, or secondary-index lookups, or uniqueness checks or anything
else?
Thanks
| |