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 factorprint(bench.get_queries()['transaction_delete_insert_same_key'])Source
Query text: benchbox/core/transaction_primitives/operations.py