Skip to content

Transactions transaction_delete_insert_same_key

Transactions benchmark · all Transactions queries

Representative SQL

Rendered in the benchmark’s native SQL with default parameters (no dialect translation available).

BEGIN TRANSACTION;
INSERT INTO txn_orders VALUES (9920001, 1, 'O', 1000.0, DATE '1998-01-01', '5-LOW', 'Clerk#000000001', 0, 'original');
DELETE FROM txn_orders WHERE o_orderkey = 9920001;
INSERT INTO txn_orders VALUES (9920001, 2, 'O', 2000.0, DATE '1998-02-01', '1-URGENT', 'Clerk#000000002', 0, 'replaced');
COMMIT;

Representative DataFrame

No DataFrame implementation is registered for this query.

Get the exact query for your run

The blocks above are representative. To get the precise statement a specific platform runs at a specific scale, substitute your own values:

from benchbox import TransactionPrimitives
bench = TransactionPrimitives(scale_factor=0.01) # your scale factor
print(bench.get_queries()['transaction_delete_insert_same_key'])

Source

Query text: benchbox/core/transaction_primitives/operations.py