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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
