mybatis-dynamic-sql icon indicating copy to clipboard operation
mybatis-dynamic-sql copied to clipboard

Add ability to provide oracle hints

Open jdafda opened this issue 3 years ago • 1 comments

Oracle has optimizer hint feature on select statements , add ability to provide this hits here is an example of PARALLEL hint

SELECT /*+ PARALLEL(4) */ customers.cust_first_name, customers.cust_last_name, 
  MAX(QUANTITY_SOLD), AVG(QUANTITY_SOLD)
FROM sales, customers
WHERE sales.cust_id=customers.cust_id
GROUP BY customers.cust_first_name, customers.cust_last_name;

jdafda avatar Feb 17 '22 03:02 jdafda