Subversion Repositories SmartDukaan

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
36691 amit 1 
-- Indexes to improve account statement query performance (selectDetailsBetween)
2 
-- returnorderinfo: full table scan (8K rows) on JOIN + date filter → range scan (1.3K rows)
3 
CREATE INDEX idx_roi_refundedat_orderid ON transaction.returnorderinfo (refundedAt, orderId);
4 
 
5 
-- returnorder: no index on createdAt for date range filter
6 
CREATE INDEX idx_ro_createdat ON transaction.returnorder (createdAt);