Magento 2 Indexer Optimization: Faster Reindexing in Production
php
dev.to
Magento's indexing system is one of the most misunderstood parts of the platform. Run it wrong and you get store lockups, slow admin saves, and customers seeing stale prices. Run it right and indexing becomes invisible. What indexers actually do Magento uses indexers to pre-compute expensive derived data and store it in flat tables optimized for reads: Indexer What it computes catalog_product_flat Flat product data (faster reads than EAV) catalog_category_flat Flat category