0
I have noticed that when I delete a store, all its sub tables should also get deleted but the product_attributes and product_attribute_terms get left behind. This can get to be a lot of extra empty tables eventually.
Also when I delete a product or category, I need to keep re-indexing manually to make sure they don’t keep appearing in the global products and categories. This process should be automatic.