查询语句：“SELECT
TOP 100 PERCENT g.*, ISNULL(s.syohinName, '') AS syohinName,
ISNULL(s.yoryo, '') AS yoryo
FROM
dbo.gendat g LEFT OUTER JOIN
dbo.syohinM s ON LTRIM(g.sku) = LTRIM(s.sku)
WHERE (g.area'z') AND (g.area'Z') AND (g.delFlg = 0)
ORDER BY g.area, g.location, g.[section], g.shelf, g.face”
环境就是：win 2000，sql server2000，机器：p42.0,512MRAM，查询用时50秒
笔记本：win xp,sql server2000,机器：cy2.0,256MRAM,查询用时9秒
用时都是平均时间，数据都是一样的！
|
