Wednesday, May 2, 2012

How do I make this SQL code faster?

any suggestions on how to make this query faster?



Also the field names are: id, sku, description, price, quantity, weight, search, pro



sorry it ms-access



SELECT *
FROM catalog
WHERE sku LIKE '1W%'
AND sku NOT IN (SELECT TOP 25 sku
FROM catalog
WHERE sku LIKE '1W%' )




No comments:

Post a Comment