SQL Performans Sırları

Bunu alanlar bunu da aldi: musteri dugumu uzerinden 2-hop GRAPH MATCH.

DECLARE @seed_product_id INT = 1041;

SELECT TOP (10)
    p2.product_id   AS recommended_product_id,
    p2.name         AS recommended_name,
    p2_cat.name     AS category,
    p2.price,
    COUNT(DISTINCT c.customer_id) AS co_buyer_count
FROM graph.product_node   p1,
     graph.purchased      pur1,
     graph.customer_node  c,
     graph.purchased      pur2,
     graph.product_node   p2,
     shop.product         p2_shop,
     shop.product_category p2_cat
WHERE MATCH(p1<-(pur1)-c-(pur2)->p2)
  AND p1.product_id = @seed_product_id
  AND p2.product_id <> @seed_product_id
  AND p2_shop.product_id = p2.product_id
  AND p2_cat.category_id = p2_shop.category_id
GROUP BY
    p2.product_id, p2.display_name, p2_shop.name, p2_shop.price,
    p2.name, p2_cat.name
ORDER BY co_buyer_count DESC;
GO

-- ----------------------------------------------------------------------------
-- (b) Tüm ürün çiftlerinin co-purchase matrisi (üst 20)
-- Workshop için ek demo: "hangi iki ürün en çok birlikte alınıyor?"

Tam betik: sql/23-graph-co-purchase.sql