Suppose you had a table that had two columns:
Sentence (varchar 255)
Due to legacy reasons, the Sentence field had duplicates in it.
What would be the quickest method to get a UNIQUE on the Sentence column as well as remove the duplicates?
The only way I’ve come up with so far is to rebuild the table from scratch with unique on. Since there are over 25 million rows, that’s gonna take a LONG time )
Any bright ideas?