Re: optimizer-hints in Forms6 ?

From: Neville Sweet <sweet.neville.nj_at_bhp_xxremovexx_.com.au>
Date: Mon, 16 Jul 2001 14:40:42 +1000
Message-ID: <9itqht$6pj$1@gossamer.itmel.bhp.com.au>

Ulrich,

Hints definitely work in Forms 6.
We had some problems with hints caused by a failure to include a space between the + and the hint. In SQL documentation prior to 8.1.5 the space was said to be optional, which is true, however in PL/SQL it is mandatory. Thus /*+RULE /* is treated as a hint in SQL but as a comment in PL/SQL, whereas /*+ RULE */ works for both.

Ulrich Pansegrau wrote in message <3B4EB504.1F5FA6FB_at_zv.fhg.de>...
>Is Forms6 really processing optimizer-hints in all places where you can
>use them?
>I ask because Forms3 treated them as comments and discarded them.
>
>Thanks, Ulrich
Received on Sun Jul 15 2001 - 23:40:42 CDT