product_id, price, and stock from a table. The existing index is on (product_id, price). Why might the query still perform poorly?product_id and price, but the query also selects stock.stock is not in the index, the database must perform a lookup on the table rows, causing slower performance.stock column, so the database must access the table rows correctly identifies the cause. The index columns are in the wrong order for the query is incorrect because column order affects filtering but not covering. The index is too large and slows down the query is speculative and not necessarily true. The query does not use any indexed columns in its WHERE clause is incorrect because the query does use indexed columns.stock column, so the database must access the table rows -> Option A15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All Questions