SQL Arena
#992

Line Items by Product

Cart analytics often matches rows in order_items to products through order_items.product_id. Add an index on order_items.product_id so line items for a product are found faster.

Speed this query up with an index
CREATE INDEX ix_order_items_product ON order_items (product_id)

Samo CREATE/ALTER/DROP — zaključni SELECT ni potreben.

Prijavite se za oddajo

Rezultat vaše poizvedbe se bo prikazal tukaj