[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Using hints in SQR 2.4.2

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