Good day guys,
I am hoping this mail finds you well.
I am at a bit of a loss here...
We are trying to run optimize against a table in order to reclaim disk
space from archived data which has been removed.
However, after running for over an hour , the optimize fails stating there
is a duplicate entry in the table.
We have now spent 2 days using various methods but we are unable to find
any duplicates in the primary key and also nothing on the unique key fields.
Any idea on why optimize would still be failing ?