range-bound queries

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 27 Jul 2009 15:29:44 -0500
Message-ID: <ad3aa4c90907271329p15058262x79c49a5075f9297b_at_mail.gmail.com>

I saw an article recently (the article is actually dated 2005), by Dan Tow and Mark Bobak showing a method of speeding up range bound queries by qualifying on rownum=1 as part of the query.


Has anyone been able to successfully do that with production SQL?

If so, are there any special conditions that make this technique safe?

Has anyone found another way to reproduce this effect?

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Received on Mon Jul 27 2009 - 15:29:44 CDT

Original text of this message