Sending hints in SQL

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

Guest

Does anyone know how to send a hint to Oracle in a pass-through query from
Access.

For example, "Select /* +STAR */ ..."

The above obviously doesn't work. Please post syntax if you know.

Thanks in advance.
 
quartz said:
Does anyone know how to send a hint to Oracle in a pass-through query from
Access.

For example, "Select /* +STAR */ ..."

The above obviously doesn't work. Please post syntax if you know.

Thanks in advance.
Click to expand...

For a pass-through query Access couldn't care less what you put in the SQL.
For Oracle SQL syntax, I suggest you try an Oracle newsgroup.
 
Why not try to put the query with hints or an execution plan in a view within
Oracle then call the view? Your issue is probably due to ODBC not supporting
Oracle specific syntax like hints. It can probably only deal with pure ANSI
SQL. Once it is in the view your query will be "pure" and Oracle will apply
the hints when it parses the view at execution.

Do you know how to call an Oracle procedure via a pass-through? If so, post
to me at Mojo110166. thanks
 
Mojo110166 said:
Why not try to put the query with hints or an execution plan in a view within
Oracle then call the view? Your issue is probably due to ODBC not supporting
Oracle specific syntax like hints. It can probably only deal with pure ANSI
SQL. Once it is in the view your query will be "pure" and Oracle will apply
the hints when it parses the view at execution.

Do you know how to call an Oracle procedure via a pass-through? If so, post
to me at Mojo110166. thanks
Click to expand...

For a passthrough query neither Access nor ODBC cares in the slightest what
is in the SQL. That's what makes it a passthrough query. As I advised him
when he posted, he needs an Oracle newsgroup to get his Oracle SQL syntax
correct.
 
Back
Top