 |
 |
Archives of the TeradataForum
Message Posted: Tue, 28 Mar 2006 @ 14:14:31 GMT
| Subj: | | Re: Tablesize Vs allspace |
| |
| From: | | Geoffrey Rommel |
| | What is the difference in the definition of peakperm in tablesize view and allspace view. | |
The difference is that AllSpace is an evil concoction that should never be used. It counts space twice! Use TableSize and DiskSpace
instead.
| | Also what is the difference between peakperm and maxperm ? | |
Quoth the Data Dictionary manual: PeakPerm "represents the maximum permanent space, in bytes, that has been used at any one time by the
database or table. Unless a specific AMP is requested, this value includes all AMPs. The ClearPeakDisk macro allows the Teradata Database
administrator to clear this field." MaxPerm is "the maximum permanent space, in bytes, that is allocated to the database on a specified AMP."
| |
