Re: how to set optimizer_index_cost_adj and cache parameters?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 26 Mar 2004 19:41:48 -0000
Message-ID: <004e01c4136a$612b8640$7102a8c0@Primary>

I missed that one completely.

Thanks - the correction is its
way to the editor.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

April 2004 Iceland http://www.index.is/oracleday.php June 2004 UK - Optimising Oracle Seminar

• Original Message ----- From: "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> To: <oracle-l_at_freelists.org> Sent: Friday, March 26, 2004 6:29 PM Subject: RE: how to set optimizer_index_cost_adj and cache parameters?

"The default cost of using the bad index is five because Oracle expects to visit one index leaf block and one table block to pick up the relevant data. 1 + 4 = 5."

You probably meant "four table blocks"

Waleed

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Mar 26 2004 - 13:38:10 CST