What happens when left table [ outer table ] is smaller when compared to right table [ inner table ] in joins.. [ outer and inner joins ]
will it affect the performance.
Join samll table with Big table
Moderator: NorbertKrupa
Re: Join samll table with Big table
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Fri May 08, 2015 9:17 pm, edited 1 time in total.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Join samll table with Big table
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.