range-bound queries

  • From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 27 Jul 2009 15:29:44 -0500

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.'

Other related posts: