Databases Reference
In-Depth Information
DELETE
FROM
Sales
.
SalesOrderDetail
WHERE
SalesOrderDetailID
=
61130
Listing 6-4.
Figure 6-3:
A per-row plan.
In addition to updating the clustered index, this delete operation will update two existing
non-clustered indexes,
IX_SalesOrderDetail_ProductID
and
AK_SalesOrder-
Detail_rowguid
, which can be seen listed on the Object property in the Properties
window of the Clustered Index Delete operator, as shown in Figure 6-4.
Figure 6-4:
Properties of the Clustered Index Delete operator.