May I ask.... What does this do?
I am not sure of exactly what it does, but it makes your database size smaller by a little bit and I guess that would make it more efficient.
I've always seen it as removing any bits of unnecessary code. I think Notepad++ has some sort of feature that goes through and removes unnecessary code, this might be similar.
So, does it remove any threads, posts, etc..?
Or it just removes unnecessary code..?
Na it doesn't remove anything that's needed, just stuff that could save a few tenths of a second in loading. I always 'Analyze and Optimize' my database when I back it up in the ACP and it always works fine for me afterwards.
When querying databases, there can be "overhead" - basically little memory leaks. It's similar to defragmenting your PC really... when you optimize your database, you put it back into order so it's easier to find.
Or that's the easier way I can explain it...