RE: Long-running SQL - huh?

Um,

You want to double check that last bit? Shouldn't it say,

A _un_bounded range scan is caused by such actions like

 Where range_id > 100

Thom Dyson
Director of Information Services
Sybex, Inc.

On 3/27/02 10:53:41 AM, "Freeman, Robert " <Robert_Freeman_at_csx.com> wrote: snip
>
> Well, depends on the type of range scan. There are two kinds, bonded and
> unbounded. Bounded is indeed intelligent and starts and stops at specific
> points. This kind of range scan you will find, for example, when the WHEN
> clause contains something like:
>
> where range_id > 100 and range_id < 300
>
> An unbounded range scan, starts at a specific place in the index and
reads
> basically the remainder of the index. A bounded range scan is caused by
> such actions like
>
> Where range_id > 100
>
> RF
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: TDyson_at_sybex.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).