Queries becoming slower after deploying vertica projections.
I was new to vertica and was given a set of queries to optimize. I generated the deployment file, by running vertica and built the projections.
However, I see that the queries have become much slower after deploying the projections. I verified the projections table to see, if the generated projections were indeed getting used and it looked to be the case.
I did some profiling and saw that the scan, network send and network receive operators were taking a lot of time. However I was not quite sure as to how to proceed further. Could someone advise here ?
I did have some joins in my query, but the scan, network send and receive operators were taking up more time according to the profiler.