Re: ORACLE Performance Hints in SQR

[Art DiRamio <ADiRamio@OPENSOLUTIONS.COM>]

We use it from time to time, and we are an Oracle shop.  We've even used it
dynamically. . .The syntax we use is as follows

Begin-Select On-Error=blahblahblah
/*+First_Rows*/         ! No spaces between anything
X
        From Dual
Where conditions
End-Select

  - - Art  :-)


        -----Original Message-----
        From:   Jerry C [SMTP:colemanj@WASHPOST.COM]
        Sent:   Friday, November 13, 1998 8:41 AM
        To:     Multiple recipients of list SQR-USERS
        Subject:        ORACLE Performance Hints in SQR

        Has anyone succeeded in doing this?  Example:

        begin-SELECT /*+FIRST_ROWS*/
        etc.

        This won't compile in SQR.  It would be nice to have the ability to
include
        hints.

        Thanks.