Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Sv: FAST_ROWS does not work properly?
To use a hint, enter:
/*+ FIRST_ROWS */
Best Regards
Karsten Weikop
Make IT ApS, Denmark
Phone: +45 26 16 06 06
E-mail: karsten_at_weikop.dk
Franz Mueller <franz.mueller_at_orbis.de> skrev i en
nyhedsmeddelelse:37ba5d66.2701584_at_news.salink.net...
> Hi,
>
> I have got an app which issues the following SQL:
> SELECT .. FROM .. WHERE Col1 like 'A%' ORDER BY Col1
> Since the answer set can be quite large I would like the server to
> output rapidly the rows (instead of maximizing the overall troughput).
> Since there is an index on Col1 I use the hint /* FIRST_ROWS */ which
> should use the index (where the data is akready sorted) and output the
> data directly. On MS-SQL-Server 7 this approach works well. On ORACLE
> it seeems no to work.
>
> Any ideas?
> Thanks
> Franz
Received on Wed Aug 18 1999 - 02:33:37 CDT