I might be being a bit short sighted but I can't find the reasoning behind Magento having a stock index when cataloginventory_stock_status
and cataloginventory_stock_status_idx
are identical in structure.
The only differences I can find at table level are:
- There's a small variation in the number of rows
cataloginventory_stock_status
has 3 foreign key constraints not found on the index table.
I assume there's going to be some reason relating to locking or certain processes where it would affect checkout but cannot find information as to why.