Below sql script I am using the delete a record from my
table.
DELETE FROM EMP WHERE
ID= 1003
|
See the execution plan.
A direct
access to the clustered index was used to identify the row that needed to be
removed and it was deleted. We may still run into situations where we will need
to validate referential integrity with DELETE operations.
No comments:
Post a Comment
If you have any doubt, please let me know.