...
Footnotes:
1) This was either kirk or patrick... I ( Jon ) recall recalls them both saying all the dup's tables could be dropped
2) This was actually part of the a script that I ( Jon ) tried created to get run in production but never was...see the jira for more info
3) this is from a test of the script mentioned in footnote #2