Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Optimization of query finding related products for a certain product
Hi everybody,
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)
AND PRODUCT_ID <> 1883577330 GROUP BY PRODUCT_ID ORDER BY
COUNT(DISTINCT USER_ID) DESC
This is the table:
VISIT
/ Jacob Received on Fri Sep 07 2001 - 05:32:34 CDT