Gregory Stark wrote:
> Mohamed <mohamed5432154321@gmail.com> writes:
>
>
>> I want to match against a boolean field, that is, only true or false is
>> possible. I am thinking Btree but not sure.. correct?
>>
>
> No index is going to be particularly effective for boolean columns unless
> they're very heavily skewed. You might find it useful to build separate
> partial indexes on other keys for each value though.
>
Gregory,
Just for the edification of the masses, can you show an example that
illustrates your point about partial indexes?
-Kevin