pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: V Chitra <vchitra@techbooks.com>
To: pgsql-admin@postgresql.org
Subject: Index called with Union but not with OR clause
Date: Fri, 20 Feb 2004 12:26:22 +0530
Message-ID: <008401c3f77e$a78f1d20$18dda8c0@VICHITRA> (raw)

Hi All,

I have a select statement 

select * from v_func_actual_costs
where parent_project='10478' or proj_pk = '10478'

both the fields parent_project and proj_pk have indexes based on them, but when I ran explain plan on this statement I found that none of the indexes are being called. But, if I make two separate statement and combine them with Union ALL, the indexes are being called. The select statement in this case is

select * from ct_admin.v_func_actual_costs
where parent_project='10478'
union all
select * from ct_admin.v_func_actual_costs
where proj_pk = '10478' 

Can anybody help me to find a reason for the same. This is just a part of the query so I cannot use the Union ALL clause.

Thanks in advance

Chitra

view thread (2+ messages)  latest in thread

Message-ID: <008401c3f77e$a78f1d20$18dda8c0@VICHITRA>
Permalink:  ../008401c3f77e$a78f1d20$18dda8c0@VICHITRA/
Also on:    postgresql.org/message-id/008401c3f77e$a78f1d20$18dda8c0@VICHITRA

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: vchitra@techbooks.com, pgsql-admin@postgresql.org
  Subject: Re: Index called with Union but not with OR clause
  In-Reply-To: <008401c3f77e$a78f1d20$18dda8c0@VICHITRA>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox