Nimesh Satam wrote:
> Following is the full plan of the query using partition. Let me know if you
> need any further information.
What indexes are there on the table partitions? You didn't post the
query, but it looks like your doing a join between rpt_network and the
partitioned table. An index on the join key might help...
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com