SQL Server execution plan cost (Continued 4)

Insert, Update, and DeleteSQLServer write operations include INSERT, UPDATE, and DELETE ). If constraints, triggers, and foreign keys are added, write operations can become more complex. Here, we only care about basic write operations. For each of the three operations, there are different icons for heap tables and clustered indexes, as shown in 2-31, 2-32, and 2-33. Insert,Update and Delete

The three write operations in SQL Server are INSERT, UPDATE, and DELETE ). If constraints, triggers, and foreign keys are added, write operations can become more complex. Here, we only care about basic write operations. For each of the three operations, there are different icons for heap tables and clustered indexes, as shown in 2-31, 2-32, and 2-33.

<