3 posts • Page 1 of 1
I don't believe that explicitly using a LIMIT improves the query performance (other than data transferred) as the optimizer must still perform the join on both tables. What I would suggest is to try to narrow your big table before the join;
Code: Select all
SELECT ... FROM small_table JOIN (SELECT ... FROM big_table WHERE some_column = 5 AND date > somedate)
Checkout vertica.tips for more Vertica resources.