Archives of the TeradataForum
Message Posted: Mon, 27 Mar 2006 @ 23:54:49 GMT
Why is that sum(peakperm) is different when it is selecte from dbc.tablesize and dbc.allspace. What is the difference in the definition of peakperm in tableszie view and allspace view.
fyi .. queries i am running are
sel databasename,sum(peakperm) from dbc.allspace where databasename='financial' group by 1; sel databasename,sum(peakperm) from dbc.tablesize where databasename='financial' group by 1;
Also what is the difference between peakperm and maxperm ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|