Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to 'stop counting' past 100 lines?

Re: How to 'stop counting' past 100 lines?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 2 Dec 2000 10:24:09 -0000
Message-ID: <975752759.8156.0.nnrp-02.9e984b29@news.demon.co.uk>

As far as 'short-circuiting' the entire
load, you also have the problem that
if the CBO decides to a sort/merge
or hash join, then most of the time
may be spent in the join anyway.

This tends to be avoided, however,
if the optimisation mode is FIRST_ROWS.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Alex Filonov wrote in message <909a07$1d6$1_at_nnrp1.deja.com>...

>First, I'm sorry for being not clear enough. Rownum works in all
>versions of Oracle. But to use order by inside of inline view you need
>8.1.
>
>Second. If you don't use sort operations: order by, group by, distinct,
>you query will be stopped after 100 rows if you use rownum <= 100. If
>you are using sort operations, you task is impossible by definition.
>
>
Received on Sat Dec 02 2000 - 04:24:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US