H2 engine chooses index internalRobotName_idx because you have expression
WHERE (S1.INTERNALROBOTNAME = 'gp1')
In current H2 version it's not possible to specify index hints. You can use
same tricks.
For complex queries more convenient to use temp tables.
CREATE TEMP TABLE IF NOT EXISTS TEMP(ID INT PRIMARY KEY, NAME VARCHAR);
CREATE INDEX IF NOT EXISTS IDX_TEMP_NAME ON TEMP(NAME);
INSERT INTO TEMP(ID, NAME)
SELECT P1.ID, P1.FIRST_NAME FROM PERSON P1 WHERE ...
H2 SQL Grammar http://www.h2database.com/html/grammar.html#create_table
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/Correlated-Subquery-Performance-tp5877p5898.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
