如何在使用Order by子句时强制执行索引？

Question

where子句和order by子句不同，那么甲骨文没有识别索引

INNER JOIN ORG_ACCOUNTING_PERIODS p 
ON p.ORG_ROADMARK = c.ORG_ROADMARK 
AND p.ACCOUNTING_PERIOD = c.SERVICE_PERIOD 
     where (c.ORG_ROADMARK =:roadMark) 
     and c.ORG_ROADMARK = c.move_road 
     ORDER BY EVENT_DATETIME; 

Answer 1

使用索引和顺序时通过，以便通过应分集的where子句，因为索引直接施加到where子句。

所以添加--->

INNER JOIN ORG_ACCOUNTING_PERIODS p ON p.ORG_ROADMARK = c.ORG_ROADMARK AND p.ACCOUNTING_PERIOD = c.SERVICE_PERIOD 
     where (c.ORG_ROADMARK =:roadMark) 
     and c.ORG_ROADMARK = c.move_road   
     and c.EVENT_DATETIME between :eventFrom AND :eventTo 
     ORDER BY EVENT_DATETIME ; 

create index --> `CREATE INDEX "CARHIRE_EVENTS_IX" ON "CARHIRE_EVENTS" ("EVENT_DATETIME", "MOVE_ROAD", "ORG_ROADMARK") ;`