On OE 11.6, RHEL 5.11 in the procedure editor: Don't remember if/when I used index hins before. But I can't get it to work. SELECT Order.orderNum, Order.entDate, Order.entCode, Order.whsLoc, Order.totMerch FROM Order WITH (INDEX(updatedAtIdx)) WHERE DATETIME('2017-09-12 00:00:00') <= updatedAt AND tranType = 'order' => ** Unable to understand after -- "FROM Order WITH". (247) ** Line 6. Invalid SQL statement. (945) Manual says this though: SELECT column_list FROM table_name [ [ AS ] table_alias ] [ WITH (INDEX ( index_val ))] ... WHERE ... Any hints?