Optimizing Tables?

[oracleguy]

I was wondering if was possible by running some SQL query to tell if a table needs to be optimized or not. And if a table didn't need to be optimized, and I was to run the optimize table command, would it preduce and ill effects?


Thanks

[Dylan Leblanc]

There must be. When I look at some of my tables using phpMyAdmin, there is an 'overhead' value that it can check.