Sending hints in SQL

[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.

 

[Brian]

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.

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.

 

[Guest]

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

 

[Brian]

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

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.