Projection Tuning Analytical function over subquery
Hi Vertica Folks,
I have query with group by on high cardinal column in subquery and analytical function over top of it. The subquery gives subsecond response but whereas the analytical function take lot of time.
My projection has group by on high cardinal values and top in the order by and established group by pipeline.
The analytical function used in Row_number over order by on measure values desc- to pick top 100.
How to tune the query further for the olap function?