Open steven-hoffman-jomashop opened 2 years ago
The lookup is by store_id and product_id. The only index on the table is the primary key. There should be an index on store_id,product_id so that the lookup should be fast. (There is no need to scan the entire table).
The lookup is by store_id and product_id. The only index on the table is the primary key. There should be an index on store_id,product_id so that the lookup should be fast. (There is no need to scan the entire table).