any optimizer HINTs in Vertica ?
In Oracle you can change behavior of query optimizer with HINTs.
Something like this
SELECT /*+ FIRST_ROWS(10) */ column_name from table_name
SELECT /*+ CHOOSE */ column_name from table_name
I know Vertica has /*+DIRECT*/ for COPY command, which makes system to bypass WOS and write directly to ROS.
What about HINTs for SELECT ?
Does it have any ?