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)
Tik CREATE/ALTER/DROP — galutinio SELECT nereikia.
Prisijunkite, kad matytumėte pateikimų istoriją
PrisijungtiPrisijunkite, kad naudotumėte DI mentorių
Prisijungti