@Anirudh D If you are doing complex joins vectorized query execution improves the performance of operations like scans, aggregations, filters and joins. For 5 rows test the difference with and without the parameters Most of those parameters you will need to test them to get the desired performance by timing the execution times. Hope that helps
... View more
