In the indexed access path initialization, we only checked the sort direction of each ORDER BY column, however we still might generate a different sort direction IndexScan node. e.g. SELECT * FROM T WHERE C1 = ? AND C2 < ? ORDER BY C1, C2. IndexScan node is doing DESC scan, then we need a ORDER BY node; but this ORDER BY is unnecessary if the statement is SELECT * FROM T WHERE C1 = ? AND C2 < ? ORDER BY C1 DESC, C2 DESC;