RE: CBO: built-in default selectivity for range scan

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Sat, 11 Nov 2000 04:17:32 +1000
Message-Id: <10676.121743@fatcity.com>

Hi Paul,

I think that's right, but I have not got time to check now. If you're curious, the way to check is to use event 10053. Its trace says exactly what selectivities are being assumed.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
From: Paul Parker [mailto:paul_g_parker_at_yahoo.com] Sent: Saturday, 11 November 2000 2:36
To: Multiple recipients of list ORACLE-L Subject: Re: CBO: built-in default selectivity for range scan

Hi Ed,

Whilst I haven't confirmed this with any tests, the doc from an internals course which I took says that the default selectivity for
bounded/unbounded range scan for bind variables is 5%.

Let me know if you find anything to the contrary.

Paul

---

Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Parker
  INET: paul_g_parker_at_yahoo.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).

Received on Fri Nov 10 2000 - 12:17:32 CST