I'm on 8.1.6 and the other day I was trying to use a hint on the
GL_INTERFACE table from Oracle Financials (i know OF is rule based)that I
had copied to another database instance and I couldnt get a hint to work.
And i know that Hint is not SQL supported and therefore the syntax has to
be 100% cor
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Connor
> McDonald
> Sent: Monday, July 01, 2002 12:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Hints being ignored
>
>
> Are you sure? I've seen t
Lee, Lee, Lee...
This is a serious RTFM question. :)
It should read:
SELECT /*+ INDEX(d CONSUMER_COMM_D2C_PK) */
Jared
Robertson Lee - lerobe <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/28/2002 07:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORA
Are you sure? I've seen two very common examples in
the past which lead people to think that hints are
ignored when in fact they have not been:
Example 1:
In SQL, select /*+HINT*/ will work, but in PL/SQL,
select /*+HINT*/ fails since the space trailing the +
is missing.
Example 2:
select /*
Do you know in what version this became the case? I certainly remember some
hints being ignored in version 8.0.
-Original Message-
Sent: Saturday, June 29, 2002 5:58 AM
To: Multiple recipients of list ORACLE-L
A hint is absolutely, positively a DIRECTIVE, not a suggestion.
Jonathan ca
A hint is absolutely, positively a DIRECTIVE, not a suggestion.
Jonathan can explain if you have doubts.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Jul 9-11 New York City
- Hotsos Clinic, Jul 23-25 Chicago
- 2003 Hotsos Symposium on OracleR Sy