Teradata Material
Pages
(Move to ...)
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
‹
›
Home
View web version
No comments:
Post a Comment