I have created DB on local as we have on server and we have the following query.
SELECT buyitem.dataid, SUM(buyitem.cost_point) AS total,itemName.itemName_C,
st_point FROM buyitem
LEFT OUTER JOIN itemName ON buyitem.dataid = itemName.itemID WHERE (buyitem.create_time > '2010/06/01') and
(buyitem.create_time < '2010/06/29') GROUP BY buyitem.dataid, itemName.itemName_C,buyite
nt ORDER BY total DESC
And also attached display estimated execution plan as following.
why both looks different on server and local