Impact of ALTER TABLE .. MOVE
Hi :
Can any one tell me the impact of running this statement.
One of my dev wants to include this in his scripts to avoid table defragmentation.
He has rewritten a query that deletes and inserts new records instead of updating the records. Select statments are slower due to fragmented tables. The above command shrinks the table and hence faster response time.
- Any negative impacts that u may think of would be appreciated.
Regards,
- BMP