I know how to use the optimize command for a table but when it is executing, why it creates a temp table?
if i have a table with 50000000 or rows, it is a good practice to use it?
using alter table, can i rebuild a table and update table statistics? How can i use it?
Thanks for your help.