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)
Just CREATE/ALTER/DROP — no trailing SELECT needed.
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in