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.
Search found 2 matches
- Mon Jan 13, 2014 6:45 am
- Forum: Vertica Performance Tuning
- Topic: Join samll table with Big table
- Replies: 2
- Views: 7138
- Mon Jan 13, 2014 6:43 am
- Forum: Vertica Performance Tuning
- Topic: order by clause has all the columns of table
- Replies: 0
- Views: 5287
order by clause has all the columns of table
What happens when projection order by clause has all the columns of table. Will it affect the performance ?