Hi ,

we too feel the same.. There is only one update which doesn't involve any indexes or any other statemets..For Simple update like the below , it is listing the above statements..

update a

set TotalQty = Tqty

from XXX_item_wise_taxes_tabl a,

(select invoice_no Tinvoice_no, sum(invoice_qty) TQty from XXX_item_wise_taxes_tabl group by invoice_no) b

where invoice_no = Tinvoice_no.

Any guesses