Thanks for clarifying, Mr. Cigarette Smoking Man. I loaned my book to someone (again). I find a lot of people could benefit from spending a week or so with that book. Whether or not they read it isn't my problem.
Lisa > -----Original Message----- > From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, March 27, 2002 1:54 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Long-running SQL > > <<It is using the index. Range scans are not "smart" so to speak. In > Harrison's sql tuning book, he states that a range scan is not > intelligent.>> > > 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 > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > > The Cigarette Smoking Man: Anyone who can appease a man's conscience can > take his freedom away from him. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
