>>>>>
>>>>>The result of SYS(3054)is:
>>>>>

&mSqlCommand
>>>>>Rushmore optimization level for intermediate result: none
>>>>>Rushmore optimization level for table ivinvt: none
>>>>>Joining table ivinvt and intermediate result using temp index

>>>>>
>>>>>Good suggestion but I don't know why it is not using Rushmore.
>>>>>
>>>>>Thanks for the help.
>>>>
>>>Did you have ORDER by K_Ivinvt of Ivinvt table?
>>>- YES
>>>
>>>Did ivinvt.k_ivinvt AND c_chng.k_ivinvt have the same length (if they are strings)?
>>>- Same Size
>>>
>>>What is SET DELETED status (WAIT WINDOW SET{DELETED]))?
>>>- SET DELETED is ON
>>
>>What type is K_Ivinvt?
>>If K_Ivinvt is some kind of numeric try:
>>

>>SYS(3054,12,[TestMe])
>>UPDATE.....
>>WHERE K_Ivinvt = 1
>>MessageBox(TestMe)
>>

>>and tell me the result.
>
>
>I moved the SQL to a stand alone prg with only the sql in it. The cursor c_chng is now a tabel with one record.
>
>If I use this code it runs in .01 seconds:
>

update ivinvt ;
> set allocated = allocated + c_chng.chng ;
> from ivinvt ;
>   join c_chng
>    on c_chng.k_ivinvt = ivinvt.k_ivinvt ;
>    where ivinvt.k_ivinvt = 'AQOPO'

>
>If I change the last line to this it take 12-15 seconds
>

where ivinvt.k_ivinvt in (select k_ivinvt from c_chng)

set enginebehavior 90

TEXT TO mSqlCommand noshow pretext 15 TEXTMERGE
  update ivinvt
  set allocated = allocated + c_chng.chng
  from c_chng
  where ivinvt.k_ivinvt == '<<PADR(ALLTRIM(c_chng.k_ivinvt),LEN(ivinvt.k_ivinvt))>>'
ENDTEXT

?