upsert
Short Description
The upsert node shows the table(s) being inserted/updated.
Detailed Description​
The upsert node shows the table(s) being inserted/updated. Rows will be inserted where the key values do not exist, or the non key values will be updated where the key values already exist. Using UPSERT can have performance advantages if all columns are being updated.
Additional Links​
- CockroachDB Docs - Upsert
- Cockroach Blog - Upsert in SQL: What is an upsert, and when should you use one?
- CockroachDB Docs - Supported Join Algorithms
- CockroachDB Docs - Cost Based Optimizer
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.