Push Oracle/Vertica/MySQL query hints

User Guide > Working with Data Sources > TDV Configuration Parameters Common to Multiple Data Sources > Push Oracle/Vertica/MySQL query hints

This setting controls whether to push Oracle style query hints to Oracle/Vertica/MySQL data sources. Query hints occur immediately after the SELECT keyword, and must begin with --+ or /*+. Regular comments will be dropped.

Data Type

Boolean

Default

False

Remarks

TDV will not validate the query hints, and Oracle/Vertica/MySQL ignores invalid query hints. TDV does not guarantee that the query hint will be pushed, as plan optimizations may cause the hint to be dropped.