solidDB Help : solidDB reference : SQL: Statements : Hints : LOOP FOR OR
  
LOOP FOR OR
The LOOP FOR OR hint is an alternative query execution plan that falls between UNION FOR OR and OR FOR OR. With LOOP FOR OR the OR values are passed individually to the data table level, but conditions like A = 1 OR B = 2 cannot be handled (see description of UNION FOR OR for details on A = 1 OR B = 2).
Example:
SELECT
--(* vendor(SOLID), product(Engine), option(hint)
-- LOOP FOR OR *)--
* FROM A LEFT JOIN B
ON A.N1 = B.N1 OR A.N2 = B.N2 OR A.N3 = B.N3;
Go up to
Hints