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
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