Revert "Dramatically boost load performance of products and categories on large stores (10,000+ products, 500+ nested categories, product filters and options) due to multi-column indexes, as explained in detail here:"

This reverts commit 58436ba44c5518afc9e2e05f6a916650be03332d.