any optimizer HINTs in Vertica ?

K_Krutiy

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]

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.