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:
http://bloke.org/php/opencart-is-slow-with-many-categories/
https://github.com/opencart/opencart/issues/177