Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Optimizing join statements
Hello, Can someone elaborate about this topic from the guide "To improve the performance of queries that perform joins, make sure that HP Vertica chooses the larger table as the outer (left hand) input by ensuring that any applicable constraints are defined." I have a query that select the small table as inner table when i do count(*) but when i select fields from both tables the optimizer swapping the order Thanks