Subversion Repositories SmartDukaan

-- Indexes to improve account statement query performance (selectDetailsBetween)
-- returnorderinfo: full table scan (8K rows) on JOIN + date filter → range scan (1.3K rows)
CREATE INDEX idx_roi_refundedat_orderid ON transaction.returnorderinfo (refundedAt, orderId);

-- returnorder: no index on createdAt for date range filter
CREATE INDEX idx_ro_createdat ON transaction.returnorder (createdAt);