Hints

Jump to bottom

Eliran Moyal edited this page Dec 30, 2015 · 3 revisions

Hint is a known SQL feature

the syntax for hints is adding it on comment before the fields after the select keyword.

select /*! YOUR_HINT*/ yourField from yourIndex

Some of the Available hints:

IGNORE_UNAVAILABLE - read about it here

SELECT /*! IGNORE_UNAVAILABLE */ * FROM index1,index2