VOS3000 删除话单 清理无通话时长话单 清理表碎片 优化表空间

VOS3000 删除话单  清理无通话时长话单  清理表碎片  优化表空间

delete from e_cdr_20220701 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220702 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220703 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220704 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220705 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220706 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220707 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220708 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220709 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220710 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220711 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220712 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220713 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220714 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220715 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220716 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220717 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220718 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220719 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220720 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220721 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220722 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220723 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220724 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220725 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220726 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220727 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220728 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220729 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220730 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220731 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220801 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220802 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220803 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220804 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220805 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220806 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220807 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220808 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220809 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220810 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220811 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220812 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220813 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220814 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220815 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220816 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220817 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220818 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220819 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220820 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220821 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220822 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220823 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220824 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220825 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220826 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220827 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220828 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220829 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220830 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220831 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220901 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220902 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220903 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220904 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220905 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220906 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220907 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220908 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220909 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220910 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220911 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220912 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220913 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220914 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220915 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220916 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220917 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220918 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220919 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220920 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220921 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220922 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220923 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220924 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220925 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220926 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220927 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220928 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220929 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20220930 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221001 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221002 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221003 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221004 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221005 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221006 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221007 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221008 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221009 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221010 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221011 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221012 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221013 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221014 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221015 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221016 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221017 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221018 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221019 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221020 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221021 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221022 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221023 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221024 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221025 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221026 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221027 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221028 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221029 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221030 where holdtime = 0 and fee = 0 and feetime=0;
delete from e_cdr_20221031 where holdtime = 0 and fee = 0 and feetime=0;

optimize e_cdr_20220701
optimize e_cdr_20220702
optimize e_cdr_20220703
optimize e_cdr_20220704
optimize e_cdr_20220705
optimize e_cdr_20220706
optimize e_cdr_20220707
optimize e_cdr_20220708
optimize e_cdr_20220709
optimize e_cdr_20220710
optimize e_cdr_20220711
optimize e_cdr_20220712
optimize e_cdr_20220713
optimize e_cdr_20220714
optimize e_cdr_20220715
optimize e_cdr_20220716
optimize e_cdr_20220717
optimize e_cdr_20220718
optimize e_cdr_20220719
optimize e_cdr_20220720
optimize e_cdr_20220721
optimize e_cdr_20220722
optimize e_cdr_20220723
optimize e_cdr_20220724
optimize e_cdr_20220725
optimize e_cdr_20220726
optimize e_cdr_20220727
optimize e_cdr_20220728
optimize e_cdr_20220729
optimize e_cdr_20220730
optimize e_cdr_20220731
optimize e_cdr_20220801
optimize e_cdr_20220802
optimize e_cdr_20220803
optimize e_cdr_20220804
optimize e_cdr_20220805
optimize e_cdr_20220806
optimize e_cdr_20220807
optimize e_cdr_20220808
optimize e_cdr_20220809
optimize e_cdr_20220810
optimize e_cdr_20220811
optimize e_cdr_20220812
optimize e_cdr_20220813
optimize e_cdr_20220814
optimize e_cdr_20220815
optimize e_cdr_20220816
optimize e_cdr_20220817
optimize e_cdr_20220818
optimize e_cdr_20220819
optimize e_cdr_20220820
optimize e_cdr_20220821
optimize e_cdr_20220822
optimize e_cdr_20220823
optimize e_cdr_20220824
optimize e_cdr_20220825
optimize e_cdr_20220826
optimize e_cdr_20220827
optimize e_cdr_20220828
optimize e_cdr_20220829
optimize e_cdr_20220830
optimize e_cdr_20220831
optimize e_cdr_20220901
optimize e_cdr_20220902
optimize e_cdr_20220903
optimize e_cdr_20220904
optimize e_cdr_20220905
optimize e_cdr_20220906
optimize e_cdr_20220907
optimize e_cdr_20220908
optimize e_cdr_20220909
optimize e_cdr_20220910
optimize e_cdr_20220911
optimize e_cdr_20220912
optimize e_cdr_20220913
optimize e_cdr_20220914
optimize e_cdr_20220915
optimize e_cdr_20220916
optimize e_cdr_20220917
optimize e_cdr_20220918
optimize e_cdr_20220919
optimize e_cdr_20220920
optimize e_cdr_20220921
optimize e_cdr_20220922
optimize e_cdr_20220923
optimize e_cdr_20220924
optimize e_cdr_20220925
optimize e_cdr_20220926
optimize e_cdr_20220927
optimize e_cdr_20220928
optimize e_cdr_20220929
optimize e_cdr_20220930
optimize e_cdr_20221001
optimize e_cdr_20221002
optimize e_cdr_20221003
optimize e_cdr_20221004
optimize e_cdr_20221005
optimize e_cdr_20221006
optimize e_cdr_20221007
optimize e_cdr_20221008
optimize e_cdr_20221009
optimize e_cdr_20221010
optimize e_cdr_20221011
optimize e_cdr_20221012
optimize e_cdr_20221013
optimize e_cdr_20221014
optimize e_cdr_20221015
optimize e_cdr_20221016
optimize e_cdr_20221017
optimize e_cdr_20221018
optimize e_cdr_20221019
optimize e_cdr_20221020
optimize e_cdr_20221021
optimize e_cdr_20221022
optimize e_cdr_20221023
optimize e_cdr_20221024
optimize e_cdr_20221025
optimize e_cdr_20221026
optimize e_cdr_20221027
optimize e_cdr_20221028
optimize e_cdr_20221029
optimize e_cdr_20221030
optimize e_cdr_20221031

optimize e_cdr_20220801