Re: Need to increase performance of a query

[Joe Conway <mail@xxxxxxxxxxxxx>]

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

Attachment: signature.asc
Description: OpenPGP digital signature