Clustered Index Update

Optimizing SQL Database Performance

Optimizing Database Performance

Clustered Index Update

The Clustered Index Update physical operator updates input rows in the clustered index specified in the Argument column.

If a WHERE:() predicate is present, only those rows that satisfy this predicate are updated. If a SET:() predicate is present, it indicates the value to which each updated column is set. If a DEFINE:() predicate is present, this lists the values that this operator defines. These values may be referenced in the SET clause or elsewhere within this operator and elsewhere within this query.

See Also

Using Clustered Indexes