Dear all,
Can anyone Please guide me with some suggestions on how to tune the
below query as I needed to perform the below query as faster as i can.
I have 3 tables on which the query runs:
pdc_uima=# select
pg_size_pretty(pg_total_relation_size('page_content_demo'));
pg_size_pretty
---
On 7/4/06, Luckys <[EMAIL PROTECTED]> wrote:
Hi all,
I got this query, I'm having indexes for PropertyId and Dates columns across
all the tables, but still it takes ages to get me the result. What indexes
would be proposed on this, or I'm helpless?
I would suggest posting your table schemas a
I don't think indexes are going to help you here - with the FULL OUTER
JOINs, the query will have to look at and include each row from each
table you query from anyway, so it's going to choose sequential scans.
In addition, some of the lower join conditions are going to take forever.
What's is
Hi all,
I got this query, I'm having indexes for PropertyId and Dates columns across all the tables, but still it takes ages to get me the result. What indexes would be proposed on this, or I'm helpless?
FROM STG_Property a FULL OUTER JOIN STG_PropConfirmedLogs b
ON (a.PropertyId = b.P
