Create a covering index with INCLUDE to avoid accessing the table. Index on category including price and stock_quantity.
Sign in to solve