How are Dml queries optimized in SQL Server?

Optimization is done for DML (Data Modification Language) commands like SELECT, INSERT, DELETE, and UPDATE. Such queries are first marked then send to the optimizer. DDL commands like CREATE and ALTER are not optimized, but they are instead compiled into an internal form.
For More Information Please Refer:

You May Also Like to Read: