Re: 11g. Incorrect results returned from query.
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 30 May 2008 15:51:30 +0100
Message-ID: <bdednd-cdOPvid3VnZ2dnUVZ8hydnZ2d@bt.com>
Date: Fri, 30 May 2008 15:51:30 +0100
Message-ID: <bdednd-cdOPvid3VnZ2dnUVZ8hydnZ2d@bt.com>
<Ralph.in.NZ_at_googlemail.com> wrote in message
news:4690406e-f86e-45a5-a7b9-4aaf67d22e16_at_26g2000hsk.googlegroups.com...
> Hi All,
>
>
> 10 rows selected.
>
> MIDASTST>8
> 8* -- WHERE transaction_subtype_type is null -- UNCOMMENT THIS LINE
> FIRST
> MIDASTST>c/--//
> 8* WHERE transaction_subtype_type is null -- UNCOMMENT THIS LINE FIRST
> MIDASTST>/
>
> no rows selected
>
> Cheers
>
> Ralph
Do you get different execution paths for the two queries ? Is the table partitioned in any way ?
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Fri May 30 2008 - 09:51:30 CDT