1 Reply Latest reply on May 14, 2010 9:40 AM by boulou

    Strange behaviour with SQL join query (via Jdbc)

    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.