we try to optimize for our queries and tried a selective update, but in explorer it just shows query execution error:
UPDATE ObjectNode o SET o.state = 5 where o.classIdentifier = '(MA)' and o.objectNameUpper = 'DMU200P2' and o.state = 0 and o.type = 1 and o.parentNode.classIdentifier = '(NC)'