Re: SQL Hints under OpenVMS/Oracle version 7.1.3

From: Wayne Linton <lintonw_at_cadvision.com>
Date: 1997/07/05
Message-ID: <33BE7217.5ABA@cadvision.com>#1/1

Some hints are ignored if not in COST mode. With CHOOSE, it probably used nested loops and indexes. Set your optimizer to COST mode in your init.ora parameters file to get the same behaviour as your PO7 V7.3

Wayne Linton
Shell Canada Ltd.

cissmjg_at_njtransit.state.nj.us wrote:
>
> I have a query that runs under Personal Oracle (7.3) with no problem. The
> basic structure is as follows :
>
> SELECT /*+ FIRST_ROWS INDEX(indexname, specific_index) ORDERED #whatever
> */ . . FROM indexname, ..., ..., . . WHERE . . AND Rownum<480 . .
>
> When I attempt to run this under OpenVMS/Oracle (7.1.3), I received the
> first 479 rows in the !physical order! of the file. If I remove the
> Rownum statement, I receive ALL of the rows in the proper order.
>
> I checked the OPTIMIZER MODE and it is set to CHOOSE. I don't know if
> this is correct or not.
Received on Sat Jul 05 1997 - 00:00:00 CDT