Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Queries give impossible results
>
> 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