Optimization of query finding related products for a certain product
Date: 7 Sep 2001 03:32:34 -0700
This query finds the related products for a certain product based on user visits.
Today this query takes 3 seconds. Is it possible to make it faster with the same result?
SELECT PRODUCT_ID FROM VISIT WHERE
USER_ID IN (SELECT DISTINCT USER_ID FROM VISIT WHERE PRODUCT_ID = 1883577330)
USER_ID INT *
PRODUCT_ID INT *
VISITDATE DATE * Thank you for your help!
/ Jacob Received on Fri Sep 07 2001 - 12:32:34 CEST