rebuild vs drop-recreate
I'm doing a table move and I would like to know what is better to do with the indexes after this table move. An index rebuild is an option, but an index drop-and-recreate would be more effective in terms of performance.
So, basically, what is better and recommended method: rebuild, drop-recreate etc? What would be the advantages and disadvantages of these methods?
Best regards
So, basically, what is better and recommended method: rebuild, drop-recreate etc? What would be the advantages and disadvantages of these methods?
Best regards
0