forked from fatdba/Oracle-Database-Scripts
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtable_set_preference.sql
18 lines (18 loc) · 3.26 KB
/
table_set_preference.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
exec dbms_stats.set_table_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',numrows=>1706395279,numblks=>46445731,avgrlen=>147);
exec dbms_stats.set_index_stats(ownname=>'DIXITTAB',indname=>'I_F2P_LBD_IX1',numrows=>1632492784,numlblks=>17657935,numdist=>204516600,avglblk=>1,avgdblk=>3,clstfct=>754876737,indlevel=>3);
exec dbms_stats.set_index_stats(ownname=>'DIXITTAB',indname=>'PK_F2P_LBD_N',numrows=>1751338167,numlblks=>12853518,numdist=>1751338167,avglblk=>1,avgdblk=>1,clstfct=>1204611215,indlevel=>3);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'CREATED_BY',distcnt=>1,density=>1,nullcnt=>0,avgclen=>7);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'CREATION_DATE',distcnt=>10259456,density=>.0000000974710549955085,nullcnt=>0,avgclen=>8);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'EVENT_START_DATE',distcnt=>30730,density=>.0000325414904002603,nullcnt=>0,avgclen=>8);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'LAST_UPDATED_BY',distcnt=>2,density=>.5,nullcnt=>0,avgclen=>8);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'LAST_UPDATED_DATE',distcnt=>2955776,density=>.00000108562780770492,nullcnt=>0,avgclen=>8);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'LINE_ITEM_ID',distcnt=>46952448,density=>.0000000212981440286138,nullcnt=>0,avgclen=>16);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'PARTITION_KEY',distcnt=>2901248,density=>.000301750150875075,nullcnt=>0,avgclen=>8);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'PLANNING_DATE',distcnt=>7853056,density=>.000000127338962055027,nullcnt=>0,avgclen=>8);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'PLANNING_ENGINE_NAME',distcnt=>3,density=>.333333333333333,nullcnt=>0,avgclen=>6);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'PLANNING_REFERENCE_ID',distcnt=>26296320,density=>.0000000380281347352025,nullcnt=>0,avgclen=>20);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'RESOURCE_NAME',distcnt=>32,density=>.00000000029690206209355,nullcnt=>0,avgclen=>16);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'RESOURCE_QUANTITY',distcnt=>642,density=>.00155763239875389,nullcnt=>0,avgclen=>4);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'SIMULATION_NAME',distcnt=>8,density=>.00000000029690206209355,nullcnt=>0,avgclen=>22);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'WAREHOUSE_ID',distcnt=>141,density=>.00000000029690206209355,nullcnt=>0,avgclen=>6);
exec dbms_stats.set_column_stats(ownname=>'DIXITTAB',tabname=>'F2P_LOAD_BALANCING_DELTAS_N',colname=>'WORKLOAD_DELTA_ENTRY_ID',distcnt=>1695547392,density=>.000000000593804124373787,nullcnt=>0,avgclen=>8);