Re: Most Performant way of performing sql query

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 23 Dec 2004 20:20:54 +0000 (UTC)
Message-ID: <cqf9b6$j5p$1@titan.btinternet.com>

Good point - my code fails to deliver if the only gap is from N+1 to 65535.

The first solution that springs to mind is to replace the T1 in the inline view with

(select id from T1 union all select 65536 from dual) I think that solves the problem - but it will have a slight effect on performance

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated Dec 23rd 2004






"Holger Baer" <holger.baer_at_science-computing.de> wrote in message 
news:cqem5e$9fk$1_at_news.BelWue.DE...


> Jonathan Lewis wrote:

>

> However, if you have a gapless dataset that just happens not to go up to 

> the 65535

> boundary, your solution doesn't find a row, so there might be a word of 

> caution

> to the OP in order.

>

> Have a very nice x-mas

>

> Holger

Received on Thu Dec 23 2004 - 14:20:54 CST