Can you use an Index Hint in a query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to use an index hint in a query? If so, could someone point
me to a good example online. My Help files are hit and miss if they work on
my computer at work, so I need an online version.

Thanks

Mark
 
AFAIK SQL Hints are an Oracle thing. Unless you are doing a pass-thru query
to Oracle, the hint won't work in Access. Even then I'm not sure as the
Oracle hint format causes an error in Access.

SELECT /*+ index */

If you want to see if Access is using a hint or not, do a Google Search on
Showplan and Access.
 
Back
Top