Quote:
Originally Posted by WarChild
Look all I know is it's not a good idea to get drunk and high and try to optimize indexes on a production database at 2AM Monday morning.
Well, so I've been told, anyway.
|
Let me guess: Drop primary index, recreate primary index with a numeric automatic increment?
I've seen that, before. The best part was that these ids were being utilized rather than a UUID or even name based key, so rebuilding the indeces to use the numerics (since the software was not to be rewritten) ended up being one hell of a task of data entry.