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%
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
.
hth
connor
--- Miller, Jay [EMAIL PROTECTED] wrote:
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
ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Hints being ignored
All
Oracle 8.0.5.0.0
Tru64 4.0f
Select statement as follows. The hint is being totally ignored. Any ideas
??
Regards
Lee
SELECT /*+ INDEX(CONSUMER_COMM_D2C CONSUMER_COMM_D2C_PK) */
i.household_id
-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 two very common examples in
the past which
not use the indexes.
From: Robertson Lee - lerobe [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Hints being ignored
Date: Fri, 28 Jun 2002 06:13:19 -0800
All
Oracle 8.0.5.0.0
Tru64 4.0f
Select statement as follows. The hint
All
Oracle
8.0.5.0.0
Tru64
4.0f
Select statement as
follows. The hint is being totally ignored. Any ideas ??
Regards
Lee
SELECT /*+ INDEX(CONSUMER_COMM_D2C
CONSUMER_COMM_D2C_PK) */
i.household_id
|| '|' || 'd'
|| '|' || d.promotion_item_id
|| '|' || xp.campaign_id
|| '|' ||