Help with Hint.
From: Harold Manary <hdmanary_at_cacd.rockwell.com>
Date: 1995/12/20
Message-ID: <4ba1rc$f53_at_newssvr.cacd.rockwell.com>#1/1
Date: 1995/12/20
Message-ID: <4ba1rc$f53_at_newssvr.cacd.rockwell.com>#1/1
I am trying to use a hint and it does not seem to be working. I have a situation similar to the example in the manual Oracle 7 Server Application Developer's Guide page 5-23. I am using Oracle 7.1.4.1.0 and SQLPLUS 2.1.4.0.0. I am trying to read the index in descending order, because it is a date and I want the most recent.
I find the retrieved row is the same with and without the hint. Is there someway I can test the hint INDEX_DESC. I know the manual has a typo and think it should be "/*+ INDEX_DESC(my_table) (date_index) */".
Also, if I get this to work, will it work inbedded in PROCOBOL? Thanks in advance. Received on Wed Dec 20 1995 - 00:00:00 CET