Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Queries give impossible results
Hi Jake,
Sorry you're having so much grief :(
Just a quick note to say that FORCE is not a valid hint (and is hence ignored), FULL is the one you're after.
Cheers
Richard
"Jake S" <nospam_at_nospam.net> wrote in message
news:W50B9.22$Ph.963_at_read2.inet.fi...
> >
> > Seems strange indeed. I would say that the 3rd and the 4th result seem
> > to conflict with each other. Is ci_customer a plain table?
> > You might suffer from bugs. Go to metalink, go to bug database searchm
> > search with the keywords 'wrong result' and expect to find dozens...
> >
> > Check the execution plan, and if any indexes are used for a query, try
> > specifying a full hint, in order to force a full table scan.
> >
> > Kind Regards,
> >
> > Herman de Boer
> > IT Consultancy Group bv.
>
> SQL> SELECT /*+ FORCE */ count(*) FROM ci_customer WHERE customer_state =
> 'ACTIVE' AND customer_type <> 'PERSON';
>
> COUNT(*)
> ----------
> 4
>
> - Jake -
>
>
Received on Fri Nov 15 2002 - 01:18:42 CST