请教各位一个很奇怪的问题,关于TOP
我有一个sql语句:
SELECT OrderDetail.Price,
OrderDetail.Vat,
OrderDetail.ArticleId,
Article.ProfitCenter,
Article.ArticleName,
OrderDetail.OrderDetailId
FROM OrderDetail, Address,Payment, [Order], Article
WHERE
Payment.OrderId = [Order].OrderId AND
OrderDetail.OrderId = Payment.OrderId AND
OrderDetail.ArticleId = Article.ArticleId AND
Payment.CustomerId = [Order].CustomerId AND
Payment.PaymethodId = 90 AND
Payment.Paydate <= '2003-03-31' AND
Payment.Paydate >= '2002-02-02' AND
OrderDetail.OrderDetailId > 0 AND
Address.CountryId = 1 AND
OrderDetail.DeliveryAddressId = AddressId
ORDER BY OrderDetail.OrderDetailId
我执行用了34秒,取出了10859条记录,