Async Concat is usually used only in distributed transactions
Async Concat will open links to remote data sources (distributed transactions) and pass rows to the next step on demand.
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.
- Google Search for sqlserver - Async Concat
- Ecosia Search for sqlserver - Async Concat
- Bing Search for sqlserver - Async Concat