Re: Using an index.

Well, I committed the cardinal sin
of this news group in my original
post - I didn't say which version of
Oracle I was using - 9.2 - and it makes
a difference.

If the obvious modification to your email address works, I've sent a couple of extra details offline.

--
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


"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message
news:lUfqa.16$k52.140_at_news.oracle.com...
>
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:b8btf2$6vp$1$8302bc10_at_news.demon.co.uk...
> > Got it in one - but which ones ?
>
> DB_FILE_MULTIBLOCK_READ_COUNT is the only parameter that DBA has
influence
> on in the above cost formulas. Unless I have cost formulas wrong.
(The
> second one is approximate, therefore the catch might be there).
>
>