Re: Need to increase performance of a query

Joe Conway wrote:
> On 06/10/2010 01:10 PM, Joe Conway wrote:
>
>> try:
>>
>> create index item_rank_null_idx on item_rank(pf_id)
>> where rank IS NOT NULL AND pf_id IS NULL;
>>
>
> oops -- that probably should be:
>
> create index item_rank_null_idx on item_rank(project_id)
> where rank IS NOT NULL AND pf_id IS NULL;
>
> Joe
>
>
I tried that and it didn't make any difference. Same query plan.

Anne