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 ?







  • Hi,

    I believe the only other documented hint (also known as directive) is the label hint as shown below.
    SELECT /*+label(myselectquery)*/ COUNT(*) FROM t;
    There are some other undocumented ones Technical Support may use temporarily for debugging optimizer issues.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file