MWF, you are absolutely correct ... my bad. Raj --- "Mark W. Farnham" <mwf@xxxxxxxx> wrote: > I think you want a minus one in the second term. > > Let's see, if block_id = 1 and you read 8 blocks, then 1...9, is *not* what > you want, so yeah, (block_id+blocks-1) > would tighten up that predicate. > > mwf __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------