Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: my problem with
On Thu, 26 Aug 2004 09:14:54 +0200, "dead"
<OVOIZBACI-vlasic_at_vodatel.net> wrote:
>it work well and need only 0.02 sec; why this work better with "minus"?
Did you run explain plan and compare the 2 plans? No? Your answer is
in the explain plan.
Also, there is no such thing as 'first 50 rows' as tables are the
representation of a set, and sets are unordered. Your approach is
likely to fail sooner or later.
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Aug 26 2004 - 04:05:22 CDT