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.
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.
http://linuxdevcenter.com/pub/a/linux/2004/01/06/rangekeyed_1.html
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.' -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 27 2009 - 15:29:44 CDT