Hints

Database
Fan

Hints

Does Teradata support Hints like /*+ driving_site(table) */
2 REPLIES
Enthusiast

Re: Hints

On our recent Teradata courses, we were told that it didn't support hints.

You need to make sure your runstats are all up to date, and the optimizer will take care of the rest.

Enthusiast

Re: Hints

The only way you can 'hint' Teradata optimizer is to collect stats and keep the statistics updated. Stale stats will lead to issues.

This thread might help - http://www.teradata.com/teradataforum/shwmessage.aspx?forumid=9&messageid=5738

This thread also talks about hints like Oracle...http://www.teradataforum.com/teradata/20060905_095943.htm