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

Home -> Community -> Usenet -> c.d.o.server -> Re: my problem with

Re: my problem with

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Thu, 26 Aug 2004 11:05:22 +0200
Message-ID: <mr9ri053gn5tnjqi4p1oil8fhvkl0mfnn7@4ax.com>


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 DBA
Received on Thu Aug 26 2004 - 04:05:22 CDT

Original text of this message

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