Re: Query gives incorrect results

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 8 Jun 2003 16:56:15 +0100
Message-ID: <bbvm8m$5v2$1$8302bc10@news.demon.co.uk>

Would you check the two execution paths, and let us know which new-looking feature appears in the plan that goes wrong.

It might be

index range (min/max)

This has a known bug in 9.2

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



____Sweden___June 9th - 11th

____Australia__June 27th (Canberra)

____Finland__September 22nd - 24th

____Norway___September 25th - 26th



Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html


____Australia_June 18th - 20th (Perth)

____Australia_June 23rd - 25th (Melbourne)

____USA_(CA, TX)_August

____UK___September


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


"Anurag Varma" <avdbi_at_hotmail.com> wrote in message
news:MBQDa.1550$av3.240_at_news02.roc.ny.frontiernet.net...
> eek ... you are correct. This does happen when you analyze the sys
schema.
>
> Anurag
>

Received on Sun Jun 08 2003 - 10:56:15 CDT