any optimizer HINTs in Vertica ?

K_Krutiy · March 2014

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 ?

Thanks

[Deleted User] · March 2014

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.

Comments