Teradata Material
Pages
Home
INFORMATICA
Fall Back,Journals and NODES
FASTLOAD
BTEQ
Teradata SQL
INDEXES
Teradata Architecture
MULTILOAD
CONTUCT US
Thursday, 26 June 2014
Query to find Skew factor of particular table
SELECT
TABLENAME
,
SUM
(
CURRENTPERM
)
/(
1024
*
1024
)
AS
CURRENTPERM
,
(
100
-
(
AVG
(
CURRENTPERM
)/
MAX
(
CURRENTPERM
)*
100
))
AS
SKEWFACTOR
FROM
DBC
.
TABLESIZE
WHERE
DATABASENAME
=
<
DATABASENAME
>
AND
TABLENAME
=<
TABLENAME
>
GROUP
BY
1
;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment