Re: Correlated Subquery Performance

2016-06-26 Thread Barrett Strausser
D 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. >>> >> >> >

Re: Correlated Subquery Performance

2016-06-26 Thread Sergi Vladykin
NDEX 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 >> >> >> >>

Re: Correlated Subquery Performance

2016-06-26 Thread Sergi Vladykin
l#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. >

Re: Correlated Subquery Performance

2016-06-26 Thread AndreyVel
sage 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.

Re: Correlated Subquery Performance

2016-06-24 Thread Barrett Strausser
TELEMETRY S1 > INNER JOIN ( > SELECT INTERNALMISSIONID FROM STATEFULROBOTTELEMETRY S3 > WHERE S3.INTERNALROBOTNAME = ? ORDER BY S3.INTERNALTIMESTAMP DESC > LIMIT 1) > S2 ON S2.INTERNALMISSIONID = S1.INTERNALMISSIONID > WHERE S1.INTERNALROBOTNAME = ? > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Correlated-Subquery-Performance-tp5877p5886.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >

Re: Correlated Subquery Performance

2016-06-24 Thread AndreyVel
= ? ORDER BY S3.INTERNALTIMESTAMP DESC LIMIT 1) S2 ON S2.INTERNALMISSIONID = S1.INTERNALMISSIONID WHERE S1.INTERNALROBOTNAME = ? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Correlated-Subquery-Performance-tp5877p5886.html Sent from the Apache Ignite Users

Correlated Subquery Performance

2016-06-24 Thread bearrito
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Correlated-Subquery-Performance-tp5877.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.