is the datatype of I&MPressureVessel3 also varchar(50)?

Run the following:

/********

set statistics profile on

go

Update blah blah

set statistic profile off

go

***//

Check the output...

Look for Index scans ...

or

returned rows vs. estimated rows where ret rows...