Home Computer Technology High-Performance Distributed DML

High-Performance Distributed DML

77
0

One of the many unique abilities of SQL databases is to transform data using advanced SQL queries and joins in a transactional manner. Commands like UPDATE and DELETE are commonly used for manipulating individual rows, but they become truly powerful when you can use subqueries to determine which rows to modify and how to modify them. It allows you to implement batch processing operations in a thread-safe, transactional, scalable manner.

Citus recently added support for …
DZone Database Zone

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.