 |
 |
Archives of the TeradataForum
Message Posted: Tue, 28 Mar 2006 @ 12:50:14 GMT
| Subj: | | Re: Tablesize Vs allspace |
| |
| From: | | Victor Sokovin |
| | Here is the content of KA S11000C100A: ALLSPACE vs DISKSPACE/TABLESIZE views described | |
...
| | There is no reason to use the AllSpace view. As pointed out, it will return twice the desired number for CurrentPerm, so there is actually
a very good reason NOT to use the AllSpace view. | |
This article might find its audience, and if the audience finds it useful I will have to abide but some sentences are just funny.
Like the above selection, for example. If some quantity is returned twice, one can do something about it, you know. Divide by 2 would be one
option. Filtering out some rows before SUMming them would be another one.
I don't know. If we were to apply the same logic to other DBC views there would be not many left to use.
Regards,
Victor
| |
