Optimizing Database Query Performance with Index-Based Scans and Concurrency Control
Predicate Pushdown to SeqScan
Integrate the Filter operator above the SeqScan operator into SeqScan itself, allowing the system to lock only rows that satisfy the predicate.
Modify the Next() function in SeqScanExecutor:
auto SeqScanExecutor::Next(Tuple *result_tuple, RID *result_rid) -> bool {
do {
if (table_iterator_ == table_info_-& ...
Posted on Thu, 14 May 2026 04:12:45 +0000 by richrock