Home » SQL & PL/SQL » SQL & PL/SQL » Re: Retrieving records N to N+10 !! Perplexed
Re: Retrieving records N to N+10 !! Perplexed [message #22168] Thu, 26 September 2002 11:07
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
OK then, it looks like the optimizer is using an index only to answer the second query (in which case the rownum will match the order). Check the plans on each query.

Report message to a moderator

Previous Topic: Simple format column to 5 spaces question
Next Topic: Result Set from ref cursor into pro*c variables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 00:07:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.