Extremely useful, but not for the uninitiated

I recommend installing this plugin on a local dev site rather than a live production site and backing up/exporting your database before and after every cleaning operation. The orphan detector is extremely helpful in cleaning up your WordPress database, but it doesn’t always identify orphans accurately. (It will usually show a percentage likelihood for tables or options that it’s not quite sure of, but if you aren’t familiar with your database structure, you might not know when it’s wrong.)

As long as you are careful, methodical, and prepared, however, this is a fantastically useful plugin. I bought the paid license for this plugin because I needed to clean up the options tables on some sites that were running VERY SLOWLY. I can easily go into phpMyAdmin to identify and delete orphan tables, but since I’m not a MySQL expert, using phpMyAdmin for orphan options would be a hair-tearing and extremely time-consuming effort. While you do need to exercise caution when deleting options, the end result is a cleaner and faster site.