Re[2]: Using hints in SQR 2.4.2

[johnk@SUN4.MITI.COM]

     Use of Oracle hints was implemented in SQR Version 3.

     John L. Kellogg
     MITI Technical Support Manager

______________________________ Reply Separator _________________________________
Subject: Re: Using hints in SQR 2.4.2
Author:  usa.net!SQR-USERS@netcomsv.netcom.com at Internet
Date:    01/11/95 7:09 AM


In SQR v3.0.7 I've done it as follows:

begin-procedure get_ar_paid
begin-select
/*+ ordered index(tbrappl ztbrappl_chg_index) use_nl(tbraccd) */

I am not sure if the 2.4.2 functionality allows this or not.


At 08:17 AM 11/1/95 -0400, you wrote:
>Does anyone know of a way to use index hints in a BEGIN-SELECT
>statement in SQR 2.4.2?  We have a need to give some of the
>SQL statements hints and can't find a way to do it.  Is an upgrade
>the answer?  Thanks in advance.
>
>                Jim Foley
>
>

Adam Hoffman
Consultant
Still-Life With Systems Inc.
RPI Phone: (518) 276-3095
RPI Email: hoffma@rpi.edu