Table Name | Records #
---------------------------|-------------
ptoassigneend_allus |3572605
---------------------------|-------------
ptoassigneend_us_identify0 | 5343
ptoassigneend_us_identify1 | 2511356
ptoassigneend_us_temp2 | 1055874
ptoassigneend_us_identify2 | 14508 ptoassigneend_us_temp3 | 1041366 ptoassigneend_us_identify3 | 664524 ptoassigneend_us_temp4 |376835 ptoassigneend_us_identify4 | 38 ptoassigneend_us_temp5 |376797 ptoassigneend_us_identify5 | 136958 ptoassigneend_us_temp6 |239837
One problem here is that the records number doesn't match6. 7% data left in ptoassigneend_us_temp6. Note:
The # of records in ptoassigneend_us_temp + # of records in ptoassigneend_us_identify0 != ptoassigneend_allus.