Re: Using an index.

I'll be describing and demonstrating those during the presentation at the IOUG-A

--
Regards

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

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____UK_______April 22nd
____USA_(FL)_May 2nd
____Denmark__May 21-23rd
____Sweden___June
____Finland__September
____Norway___September

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK_(Manchester)_May x 2
____Estonia___June (provisional)
____Australia_June (provisional)
____USA_(CA, TX)_August

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


"koert54" <nospam_at_nospam.com> wrote in message
news:Xnfqa.62175$t_2.5425_at_afrodite.telenet-ops.be...


> will you investigate the relationship with

> - optimizer_index_caching and

> - optimizer_index_cost_adj

>

> it seems to me that in OLTP, switching from RBO to CBO will make 80%

of my


> queries go faster but... 20% will go slower

> Adjusting the parameters above mostly does the trick for me so I

don't have


> to add

> hints all over the place

>

>