Collapse
Short Description
The Collapse operator optimises update processing
Detailed Description​
Updates can be made more efficient by separating then into delete and insert steps. If the query processor comes across adjacent rows that would be deleted and re-inserted it replaces the separate actions with a single one.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.