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

I'm getting used to the weird problems :) I didn't have time to check syntax, so this is the correct one?

SQL> SELECT /*+ FULL */ count(*) FROM ci_customer WHERE customer_state = 'ACTIVE' AND customer_type <> 'PERSON';

  COUNT(*)

         4

SQL> SELECT /*+ FULL */ count(*) FROM ci_customer WHERE customer_type <> 'PERSON' AND customer_state = 'ACTIVE';

  COUNT(*)

         4

• Jake -