AnsweredAssumed Answered

Strange behaviour with SQL join query (via Jdbc)

Question asked by boulou on May 14, 2010
Latest reply on May 14, 2010 by boulou

Title

Strange behaviour with SQL join query (via Jdbc)

Your post

 

FYI, I noticed big difference in speed depending on how you write SQL select queries:

 

This one is slow:

select * from A, B where A.node_id = B.node_id and B.parent_node_id = 0

 

This one is 20 times faster:

select * from B inner join A on A.node_id = B.node_id where B.parent_node_id = 0;

 

b.

Outcomes