Query performance varying with LIMIT keyword

[nunob]

Hello,

I have table A with PK (col1, col2, col3) and table B with PK (col1, col2
col3)

Both tables have around 300k records.

This query executes in *2ms*:

/SELECT * FROM table_a a
LEFT JOIN table_b b ON  b.col1 = a.col1
                             AND b.col2 = a.col2
                             AND b.col3 = a.col3
*LIMIT 1 *OFFSET 0;/

This query executes in *1.4s*:

/SELECT * FROM table_a a
LEFT JOIN table_b b ON  b.col1 = a.col1
                             AND b.col2 = a.col2
                             AND b.col3 = a.col3
*LIMIT 10 *OFFSET 0;/

Shouldn't the execution time be the same for both queries or am I missing
something?



Regards,

Nuno





--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/