|
|
Archives of the TeradataForum
Message Posted: Fri, 24 Mar 2006 @ 16:02:27 GMT
Subj: | | Re: PPI Range Maintance |
|
From: | | Vollmer, James |
We've implemented PPI on tables of similar size with very good results.
| From a maintenance perspective, we alter the PPI by simply extending it at a pre-determined interval. (For us, it's a month 1/2 after year-
end). | |
There's no need to drop/recreate the table and I don't believe stats collection should be needed (Those that are much more in-tune with the
platform may correct me!)
| |