OBIA on Teradata - Part 3 Stats
Posted
by Mohan Ramanuja
on Oracle Blogs
See other posts from Oracle Blogs
or by Mohan Ramanuja
Published on Thu, 6 Sep 2012 14:04:00 +0000
Indexed on
2012/09/06
15:45 UTC
Read the original article
Hit count: 259
/Oracle/OBI
Statements to run table stats on W_Party_Per_DS and W_Party_Per_D
COLLECT STATISTICS ON W_PARTY_PER_DS COLUMN ("DEPARTMENT_NAME");
COLLECT STATISTICS ON W_PARTY_PER_DS COLUMN ("CONTACT_ID");
COLLECT STATISTICS ON W_PARTY_PER_DS COLUMN ("CITY");
COLLECT STATISTICS ON W_PARTY_PER_D COLUMN ("ACCNT_FLG");
COLLECT STATISTICS ON W_PARTY_PER_D COLUMN ("SUPPLIER_FLG");
help statistics w_party_per_d;
10/06/02 15:37:47 5,002,185 ROW_WID
10/06/21 14:02:55 0 VIS_PR_POS_ID
10/06/02 15:37:48 2 CREATED_BY_WID
10/06/02 15:37:49 2 CHANGED_BY_WID
10/06/02 15:37:50 2 SRC_EFF_FROM_DT
10/06/02 15:37:51 1 SRC_EFF_TO_DT
10/06/02 15:37:52 2 EFFECTIVE_FROM_DT
10/06/02 15:37:53 2 EFFECTIVE_TO_DT
10/06/02 15:37:57 1 DELETE_FLG
10/06/21 14:02:54 0 CURRENT_FLG
10/06/02 15:37:59 2 DATASOURCE_NUM_ID
10/06/02 15:38:02 1 ETL_PROC_WID
10/06/10 18:27:21 1,000 INTEGRATION_ID
select top 10 * from DBC.TableSize;
select vproc, CurrentPerm from DBC.TableSize where databasename = 'PRJ_CRM_STGC' and tablename='w_party_per_d' ORDER BY 2 DESC;
Vproc DataBaseName AccountName TableName CurrentPerm PeakPerm
0 PRJ_CRM_STGC DBA/DBA W_PARTY_PER_D 8704.00 841728.00
3 PRJ_CRM_STGC DBA/DBA W_PARTY_PER_D 8704.00 782848.00
© Oracle Blogs or respective owner
